Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Formatting and Customizing Charts
For a bit more control, follow these steps:
1. Click the series to select it.
2. Choose Chart Tools Format Shape Styles Shape Fill, and select a color.
3. Choose Chart Tools Format Shape Styles Shape Outline, and select a color for the
outline of the columns.
You can also modify the outline width and the type of dashes (if any).
4. Choose Chart Tools Format Shape Styles Shape Effects, and add one or more effects to
the series.
Note that you can modify the Shape Fill, Shape Outline, and Shape Effects for almost every element
in a chart.
Here’s one way to change the formatting of a chart’s title so that the text is white on a black background:
1. Click the chart title to select it.
2. Choose Chart Tools Format Shape Styles Shape Fill, and select black.
3. Choose Chart Tools Format WordArt Styles Text Fill, and select white.
Notice that some of the controls in the Home Font and Home Alignment groups are also available
when a chart element is selected. An alternate way of changing a chart’s title to white on black is as
follows:
1. Click the chart title to select it.
2. Choose Home Font Fill Color, and select black.
3. Choose Home Font Font Color, and select white.
The Ribbon commands do not contain all possible formatting options for chart
elements. In fact, the Ribbon controls contain only a small subset of the chart formatting
commands. For optimal control, you need to use the Format dialog box (discussed later
in this chapter).
Note
Formatting by using the Mini Toolbar
When you right-click a chart element, Excel displays its shortcut menu, with the Mini Toolbar on top.
Figure 7-2 shows the Mini Toolbar that appears when you right-click a chart title. Use the Mini
Toolbar to make formatting changes to the selected element. Note that the Mini Toolbar also works if
you’ve selected only some of the characters in the chart element. In such a case, the text formatting
applies only to the selected characters.
Search JabSto ::




Custom Search