Adjusting gridlines on the x-axis

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
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do I get some missing minor gridlines in an excel chart? 3
How do you align the x axis to the gridlines? 1
Move gridlines in a chart so that they are above the numbers 1
Gridlines & Tick marks 1
Secondary axis not aligning to X axis 1
2007 line chart, can't make some gridlines heavier than others 10
Horizontal axis to the bottom 1
Make Y-axis values correspond to x- axis value 1

Top