Manually Setting Tick Marks on a Chart
Posted by Tom on February 01, 2001 7:44 AM
Does anyone know how to manually setup the tick marks on a chart using VBA. I know you can set MinimumScale, MaximumScale, MinorUnit, MajorUnit properties on the Axes object. But this doesn't give me the flexibility that I need. I need to be able to set each of the tick marks individually.
Basically, I'm trying to chart the Standard Deviation from the mean. And I need to tick marks on my grid to be the mean plus and minus x standard deviations.
Then I need to come back and plot a series of numbers against this grid.
Any suggestions would be greatly appreciated.