Updating Axis tickmark/ticklabel spacing (1 Viewer)

[benti]

I'm generating charts in a form from VBA, and have two problems connected to this:

1. I'm using the following code to set the spacing for tickmark/ticklabel

Forms(frmxxx).ctlxxx.object.Axes(xlcategory).TickMarkSpacing=5
Forms(frmxxx).ctlxxx.object.Axes(xlcategory).TickLabelSpacing=5

This is working fine-But never the first time I'm running my code. I allways need to run my code twice to get it to work.

Have allready tried

Forms(frmxxx).ctlxxx.object.Reload

2.
When the input on x-axis is of date-formate, it has been impossible for me to set the tickmark/ticklabel spacing at all.

 

[pottera]

I don't know a thing about charts, but where have you put the code? (eg Form_Open event?)

 

[benti]

The code is put under a click-event on a seperate form