Microsoft Office Tutorials and References
In Depth Information
Formatting the Chart Columns
Figure 4-17
Formatted chart axes
major tick mark
values are
percentages with
no decimal places
vertical axis scale
ranges fro m 0%
to 25% in 5%
both axes have a
smaller font size
Formatting the Chart Columns
In a pie chart, each slice or data marker has a different format. In a column chart, all of
the columns usually have a common format because the columns are distinguished by
height, not color. (However, you can format individual columns in a data series to
highlight a particular column value.) You can modify the appearance of the data markers in a
column chart using a variety of formatting options.
Ajita thinks that the columns are spaced too widely and could be formatted more
attractively. You will reduce the gap between the columns, and change their fi ll color and
appearance to make the columns stand out.
To format the chart columns:
1. Click the Chart Tools Layout tab on the Ribbon, and then click the Chart
Elements arrow in the Current Selection group. The list includes each element
you can select in the column chart.
You can also select a
data series by clicking
any of its columns in the
column chart.
2. Click Series “New Century” . All the columns for the data series in the chart are
3. In the Current Selection group, click the Format Selection button. The Format
Data Series dialog box opens with the Series Options displayed.
4. Drag the Gap width slider to 50% to reduce the gap between adjacent columns.
The columns become wider to fill the space.
Trouble? If you cannot drag the Gap width slider to exactly 50%, type 50 in the
Gap width box below the slider.
5. Click Fill on the left side of the dialog box, and then click the Gradient fill option
button to fill the columns with a gradually changing mix of colors.
Search JabSto ::

Custom Search