Double click on the axis, and adjust the settings on the Scale tab.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"WATYF" wrote in message
ups.com...
I need to know how to change the number of Z-Axis values/gridlines
that show up along the bottom of a chart.
My problem is, Excel is automatically choosing the number of
gridlines, and for some crazy reason, it's displaying so many
gridlines that the values for each line are bunching together and
overlapping or wrapping to two rows. I only want 5 or 6 gridlines on
my chart at all times, no matter what the values are. How do I specify
that?
WATYF