Page 547 - Excel 2013 All-in-One For Dummies

Worksheet Charting 101 529
Customizing chart elements from the Format tab
The command buttons on the Format tab on the Chart Tools contextual tab make it easy to customize particular parts of your chart. Table 1-2 shows you the options that appear on the Format tab. Note that depending on
the type of chart that’s selected at the time, some of these options may be unavailable.
Table 1-2
Tab Group
Current Selection
Option Name
Chart Elements
Format Selection
Reset to Match Style
Shape Styles
Shape Fill
Shape Outline
Format Tab Options
Purpose
Click this command button to select a new chart element by choosing its name from the button’s drop-down menu.
Click this command button to open a Format dialog box for the currently selected chart ele- ment as displayed on the Chart Elements drop- down list button.
Click this command button to remove all custom formatting from the selected chart and to return it to the original formatting bestowed by the style selected for the chart.
Click the thumbnail of the shape you want to add to your chart on the drop-down gallery with a whole bunch of preset graphic shapes. (See Book V, Chapter 2 for details.)
Click the Shape Styles’ More button to display a drop-down gallery in which you can preview and select new colors and shapes for the cur- rently selected chart element as displayed on the Chart Elements drop-down list button.
Click this command button to display a drop- down color palette in which you can preview and select a new fill color for the currently selected chart element as displayed on the Chart Elements drop-down list button.
Click this command button to display a drop- down color palette in which you can preview and select an outline color for the currently selected chart element as displayed on the Chart Elements drop-down list button.
(continued)
Insert Shapes
Shape Styles
Book V Chapter 1
Charting Worksheet Data