Microsoft Office Tutorials and References
In Depth Information
Axis number formats
Axis number formats
A value axis, by default, displays its values using the same number format 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.
Figure 4-29: The Axes tab of the Chart Options
dialog box
Don’t forget about custom number formats. Figure 4-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.
Don’t Be Afraid to Experiment — on a Copy
I’ll let you in a secret: The key to mastering charts in Excel is experimentation,
otherwise known as trial and error. Excel’s charting options can be overwhelming,
even to experienced users. This topic, despite being almost comprehensive, doesn’t
even pretend to cover all the charting features. Your job, as a potential charting guru,
is to dig deep and try new options with your charts.
After you’ve created a basic chart, you might want to make a copy of the chart for your
experimentation. That way, if you mess it up you can always revert to the original. To
make a copy of an embedded chart, press the Ctrl key while you click the chart and
drag the mouse pointer to a new location. To make a copy of a Chart sheet, press Ctrl
while you click the sheet tab and drag it to a new location among the other tabs.
Search JabSto ::

Custom Search