Discussion Locked

Set major gridlines - charting in Excel

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to custom set major gridlines in Excel charts? I know how to space them evenly, but I need each gridline to be set at variable distances.

Also, is there a way to set a drawn in line as a major gridline?

8 replies

by red dragoon

I just experimented with this, and the only way I can figure it out (after having consulted Microsoft's support site) is to insert those lines on your own.

Open the chart that you want to customize. Then bring up the Drawing toolbar.

You can use the drawing tools to add your own lines and text boxes right onto the chart. If you don't believe it, just do a Print Preview.

It's especially nice if you have a color printer, so you can add colored lines to emphasize important benchmarks and so on.

Have fun with it!

This discussion is closed to new replies.