Page 163 - Excel Data Analysis

09 537547 Ch08.qxd 3/4/03 12:06 PM Page 149

CREATING PIVOTCHARTS 8

You can create a custom chart type to use for If you do not like the appearance of the chart
your PivotCharts. A custom chart type, or elements on your PivotChart, you can change the
user-defined, is a template for the layout of your formatting. To do so, select the desired chart
PivotChart. When you create a custom chart element and click Format ➪ Selected Element,
type, Excel stores all the information about the where Element is the name of the selected chart
appearance of the PivotChart, including the chart element. Depending on the element selected,
type, color changes, fonts, legends, and even different formatting options are available on several
data tables. After you create a custom chart type, tabs in the Format dialog box.
you can select it from the Custom Types tab of
the Chart Type dialog box when you create a
PivotChart. To view the custom chart types that
you have created, click User-defined ( changes
to ). You can view a sample of the custom
chart type with your data in the Sample box. See
Chapter 6 for more information on creating a
custom chart type.

Bar

■ A preview of the ■ If the chart type is not ■ Excel updates the
PivotChart with the new valid, an error message PivotChart to the new
chart type appears in the appears in the Sample box. chart type.
Sample box.
Á Click OK.

149