Microsoft Office Tutorials and References
In Depth Information
Setting Label Units
Figure 4-23
Rescaled vertical and horizontal axes
value axis scale
ranges from 0 to
20,000 in 5,000 unit
category ax is displays
the four-digit year
The category axis shows four-digit year values for 2004, 2006, 2008, 2010, and 2012.
Because fewer years are included on the axis, there is enough room to display the labels
horizontally instead of vertically.
Setting Label Units
When a chart involves large numbers, the axis labels can take up a lot of the available
chart area and be diffi cult to read. You can simplify the chart’s appearance by
displaying units of measure more appropriate to the data values. For example, you can display
the value 20 to represent 20,000 or 20,000,000. This is particularly useful when space is
at a premium, such as in an embedded chart confi ned to a small area of the worksheet.
When you select the display units, such as Thousands, you can choose to show the
display unit in the axis title.
The Fund History line chart displays data in tens of thousands of dollars. Rather than
displaying a large value such as 20,000, Ajita wants to save space by displaying numbers
in units of thousands. You will change the display units for the value axis but not show
the units in the axis title.
To set the display unit for the value axis:
1. Double-click the value axis to open the Format Axis dialog box with the Axis
Options displayed.
2. Click the Display units arrow, and then click Thousands .
3. Move the dialog box so you can see the line chart’s value axis. The scale of the
value axis changed from 0 to 20,000 in intervals of 5,000 to 0 through 20 in
intervals of 5. The axis title “Thousands” indicates that the values are expressed in
units of 1000. To save space, you’ll remove this title from the chart.
4. Click the Show display units label on chart check box to remove the check
mark. The axis title is removed from the chart.
Search JabSto ::

Custom Search