How do you align the x axis to the gridlines?

G

Guest

The gridlines differ from my x axis. The x axis crosses in the middle of
gridlines. I want it to be right under the gridline
 
J

Jon Peltier

Double click the axis, and uncheck the box for 'Axis Crosses Between
Categories'.

- Jon
 

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

Secondary axis not aligning to X axis 1
Why do I get some missing minor gridlines in an excel chart? 3
2007 line chart, can't make some gridlines heavier than others 10
Adjusting gridlines on the x-axis 1
Move gridlines in a chart so that they are above the numbers 1
category (X) axis gridlines 1
Gridlines & Tick marks 1
Delete selected major gridlines in a chart 1

Top