Microsoft Office Tutorials and References
In Depth Information
Here, I’ve underlined the argument that has changed in the second
How to Manage the Y Axis
The Y axis often has the same
problem as the X axis: It takes
up too much horizontal space.
We therefore need to find ways
to reduce that space.
Two steps are obvious. One
step is to remove the dollar sign,
or other currency symbol. The other step is to display the Y axis
using fewer zeros.
To remove the currency symbol, select the data in your
spreadsheet. Choose Format, Cells. Choose the Number tab in the
Format Cells dialog. In the list of categories, choose Custom. Then
enter the format code: #,##0,
Be sure to enter the comma that follows the
zero in this number format. That comma
tells Excel to display results to the nearest
thousands of dollars, not to the nearest
After you adjust the Y-axis formats, you
probably can reduce the width of your chart
even more. The chart in this figure is half the width of the chart in
the previous figure.
This change has created several problems, of course. This chart
doesn’t tell us whether sales were 10 dollars or 10 million euros.
Chapter 8 explains how to fix this problem.