I've created a pivotchart and I need to change the lables spacing and Tick mark spacing based upon the length of time the user has selected. I.E. if the user wants to show data for 12 months then the lables spacing is 1 and the tick mark spacing is 1, if the user wants to show 36 months then the spacings change to 3 each, etc.
I don't know how to change theses settings in VBA. And where would be the best place to put the code? The pivotchart form is a subform of a report.
Thank you in advance.