Microsoft Office Tutorials and References
In Depth Information
Working with Gridlines
Figure 4-30: The value axis uses a custom number format to provide units
for the values.
Working with Gridlines
Gridlines can help the viewer determine the values represented by the series in the
chart. Gridlines are optional, and you have quite a bit of control over the
appearance of gridlines. Gridlines simply extend the tick marks on the axes. The tick
marks are determined by the major unit and minor unit specified for the axis.
Gridlines are applicable to all chart types except pie charts and doughnut
Some charts look better with gridlines; others appear more cluttered. It’s up to
you to decide whether gridlines can enhance your chart. Sometimes, horizontal
gridlines alone are enough, although XY charts often benefit from both horizontal
and vertical gridlines.
Adding or removing gridlines
To add or remove gridlines, use the Chart
Options command and select the
Gridlines tab. Each axis has two sets of gridlines: major and minor. Major units are
the ones displaying a label. Minor units are those between the labels. You can
choose which to add or remove by checking or unchecking the appropriate check
boxes. If you’re working with a chart that has a secondary category axis, a
secondary value axis, or a series axis (for a 3-D chart), the dialog box has additional
options for three sets of gridlines.
Search JabSto ::

Custom Search