Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Formatting and Customizing Charts
Figure 7-2: You can use the Mini Toolbar to format chart elements.
A few of the common keystroke combinations also work when a chart element that contains text is
selected — specifically: Ctrl+B (bold), Ctrl+I (italic), and Ctrl+U (underline).
Formatting by using the Format dialog box
For complete control over text element formatting, use the Format dialog box. Each chart element
has a unique Format dialog box, and the dialog box has several tabs.
You can access the Format dialog box by using either of the following methods:
➤ Select the chart element and press Ctrl+1.
➤ Right-click the chart element and choose Format xxxx from the shortcut menu (where xxxx is
the chart element’s name).
In addition, some of the Ribbon controls contain a menu item that, when clicked, opens the Format
dialog box and displays a specific tab. For example, when you choose Chart Tools➜Format➜Shape
Outline➜Weight, one of the options is More Lines. Click this option, and Excel displays the Format
dialog box with the Border Styles tab selected. This tab enables you to specify formatting that’s not
available on the Ribbon.
Figure 7-3 shows an example of a Format dialog box. Specifically, the figure shows the Legend
Options tab of the Format Legend dialog box. As noted, each chart element has a different Format
dialog box, which shows options that are relevant to the chart element.
The Format dialog box is a stay-on-top dialog box. In other words, you can keep this
dialog box open while you’re working on a chart. It’s not necessary to close the dialog box
to see the changes on the chart. In some cases, however, you need to activate a different
control in the dialog box to see the changes you’ve specified. Usually, pressing Tab will
move to the next control in the dialog box and force Excel to update the chart.