Microsoft Office Tutorials and References
In Depth Information
Editing the Axis Scale and Text
To remove the legend and format the chart title of the column chart:
1. Click the Chart Tools Layout tab on the Ribbon.
2. In the Labels group, click the Legend button, and then click None . The chart
legend is removed from the chart, and the column chart resizes to fill the
available space.
3. Click the chart title to select it, and then click the Home tab on the Ribbon.
4. In the Font group, click the Font Size arrow , and then click . The chart title is 12
reduced to 12 points, and remains selected.
5. Type Sector Percentages as the new chart title, and then press the Enter key.
Editing the Axis Scale and Text
The vertical or value axis shows the range of series values, and the horizontal or category
axis shows the category values. The range of values, or scale , of an axis is based on the
values in the data source. The default scale usually ranges from 0 (if the data source
has no negative values) up through the maximum value. If the scale includes negative
values, it ranges from the minimum value up through the maximum value. Excel divides
the scale into regular intervals, which are marked on the axis with tick marks and labels.
For example, the scale of the vertical axis for the Sector Percentages chart ranged from
0.00 percent up to 16.00 percent in increments of 2.00 percent. Having more tick marks
at smaller intervals could make the chart more diffi cult to read because the tick mark
labels might start to overlap. Likewise, having fewer tick marks at larger intervals could
make the chart less informative. Major tick marks identify the main units on the chart
axis. You can also add minor tick marks to identify smaller intervals between the major
tick marks. Gridlines extend the tick marks across the plot area.
Some charts involve multiple data series that have vastly different values. In those
instances, you can plot one data series against a primary axis , which usually appears
along the left side of the chart, and the other against a secondary axis , which is usually
placed on the right side of the chart. The two axes can use different scales and labels.
By default, no titles appear next to the value and category axes. This is fi ne when the
axis labels are self-explanatory; otherwise, you can add descriptive axis titles. In general,
you should avoid adding extra chart elements such as axis titles when that information is
easily understood from other parts of the chart.
Ajita thinks that the value axis scale is too crowded and wants tick marks placed at
5 percent intervals, ranging from 0 percent to 25 percent. You will modify the scale of the
value axis.
To change the scale of the vertical axis:
1. Click the Chart Tools Layout tab on the Ribbon.
2. In the Axes group, click the Axes button, point to Primary Vertical Axis , and
then click More Primary Vertical Axis Options . The Format Axis dialog box
opens with the Axis Options displayed. The value axis options are set to Auto,
which causes Excel to set the values.
3. Next to Maximum, click the Fixed option button, and then type 0.25 in the box.
The maximum value will be 25 percent.
4. Next to Major Unit, click the Fixed option button, and then enter 0.05 in the box.
The major tick marks will appear at 5 percent intervals. See Figure 4-16.
Search JabSto ::




Custom Search