Adjusting gridlines on the x-axis

  • Thread starter Thread starter Eli
  • Start date Start date
E

Eli

i have a graph that runs from 1 to 32 on the x-axis and 0
to 3 on the y-axis. i want to adjust the gridlines on
both axes to 1x1 and .5x.5 and .25x.25. adjusting the y-
axis gridlines is easy, i just double click on the y-axis
and enter whatever values i want for each gridline.
however on the x-axis i am stuck with gridlines at 1 for
the major gridlines and .5 for the minor gridlines.
anybody know how i can change the x-axis gridline to .25

thanks
 
Eli -

You only have this amount of control over a value axis, not a category
axis. To get a value axis on the X axis, you need to make an XY Scatter
chart, not a Line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top