Page 165 - Excel Data Analysis

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

CREATING PIVOTCHARTS 8

Although a PivotChart works well for moving When you hide the field buttons that display on
around fields to create a desired analysis, once your PivotChart, Excel removes all buttons as well as
you have the chart laid out and established the the PivotTable Field List. To hide buttons, click
way you want, you may consider removing the PivotChart ➪ Hide PivotChart Field Buttons. To
field buttons that display in the Page, Category, restore the buttons, click the option again. You can
Data, and Series areas. When you do so, the find the PivotChart option on the PivotTable
chart looks like a standard Excel chart and toolbar. The toolbar displays when you view a
becomes more presentable for printing or PivotTable or PivotChart. If you cannot find the
display purposes. Hiding buttons also protects toolbar, you can display it by clicking View ➪
your chart from unwanted changes; users cannot Toolbars ➪ PivotTable.
change the layout of your chart when they
cannot access buttons. See Chapter 1 for
information on protecting a worksheet.

1009

‹ Click each item that you › Click OK. ■ The PivotChart updates
want on the PivotChart. automatically to display only
the selected items.

151