MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.



Posted by Mark W. on February 01, 2001 8:12 AM

Tom, I don't understand. Aren't your category (X-axis)
values Sigmas.

Posted by Tom on February 01, 2001 8:46 AM

Basically I have a series of numbers that I want to plot. I'm using an YXScatter chart to plot them, but for each series I am setting the Y-Axis to 0 so that will all plot along the same Y-Axis.

Series of Data to Plot

AZ .0
CA 5.25
GA -2.0
MA -1.0
OR 2.25

But here is the thing. I want to plot them along a grid that uses a completely different set up numbers.



The problem I'm having it setting up the grid with these gridlines.

Here is the grid I'm trying to get;




Posted by Mark W. on February 01, 2001 11:39 AM

Tom, did I understand you to say that your
X values = {0;5.25;-2.0;-1.0;2.25} and your
Y values = {0;0;0;0;0}.