Microsoft Office Tutorials and References
In Depth Information
Editing the Axis Scale and Text
Figure 4-16
Axis options in the Format Axis dialog box
click to set the
number form at of
the tick mark values
axis scale
rang es from
0% to 25% in
5% increments
click to define the
appearance of the
tick mark values
click to set the
alignment of the
tick mark values
tick marks
appe ar next
to the axis on
the outside
placement of the
horizontal
(category) axis
5. Click Number on the left side of the dialog box, make sure Percentage is
selected in the Category box, and then type in the Decimal places box. The 0
percentage values in the vertical axis will show no decimal places.
6. Click the Close button. The percentages on the value axis range from 0 percent to
25 percent in 5 percent intervals with no decimal places.
These changes make the value axis easier to read. Ajita also thinks that the font size of
both the value axis and the category axis is too large, dominating the rest of the graph.
You will reduce the font size of the axes so that more of the chart area is available for the
column chart itself.
To modify the font size of the axis titles and labels:
1. Make sure that the vertical axis is still selected, and then click the Home tab on
the Ribbon.
2. In the Font group, click the Font Size arrow , and then click . The values 8
played in the vertical axis are smaller, leaving more room for the data series.
3. Click anywhere within the category axis to select it, and then change the axis
font size to points. The revised column chart is easier to read. See Figure 4-17. 8
Search JabSto ::




Custom Search