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.

Thanks,

Tom


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.

Example:
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.

GridLines:

-5.5
-1.0
0
3.5
8.0

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

Here is the grid I'm trying to get;

-5.5----1.0----0----3.5----8.0
OR MA AZ OR CA


Thanks,

Tom

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}.