Gridlines

Gridlines are lines indicating major and minor scale points along a chart's walls. They can make it easier to follow chart points to corresponding values on a chart axis. Pie and doughnut charts do not have gridlines.

Tip

  • Although gridlines can make a chart's data easier to read, too many gridlines can clutter a chart's walls, making data impossible to read.

To set gridlines

1.
In the Chart Options dialog, click the Gridlines tab to display its options (Figure 50).
2.
Turn on the check boxes for the gridlines you want to display on each axis:

  • Major gridlines correspond to major tickmark units for the axis scale.

  • Minor gridlines correspond to minor tickmark units for the axis scale.

3.
To apply a 2-D appearance to 3-D chart walls and ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial