Microsoft Office Tutorials and References
In Depth Information
Working with Gridlines
Axis number formats
A value axis, by default, displays its values using the same number format that’s used by the chart’s
data. You can provide a different number format, if you like, by using the Number tab of the Format
Axis dialog box. Changing the number format for a category axis that displays text will have no
effect.
Don’t forget about custom number formats. Figure 7-30 shows a chart that uses the following
custom number format for the value axis:
General “ mph”
This number format causes the text mph to be appended to each value.
Figure 7-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 on 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 charts.
Note
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 scatter charts often benefit from both horizontal and vertical gridlines. In many cases,
gridlines will be less overpowering if you make them dashed lines with a gray color.
Search JabSto ::




Custom Search