Microsoft Office Tutorials and References
In Depth Information
Hiding the pivot chart field buttons
Hiding the pivot chart field buttons
Pivot charts contain controls (known as field buttons ) that enable you to
manipulate the information displayed. These controls are analogous to the similar controls
used in a pivot table. As you’ve probably noticed, these field buttons can make a
chart look terrible. If you would like to hide these controls, right-click any one of
them and then choose Hide PivotChart Field Buttons from the shortcut menu.
To re-display the hidden field buttons, you need to make sure that the PivotTable
toolbar is displayed. Then, click the PivotChart button and select Hide PivotChart
Field Buttons (this menu item is a toggle). Keep in mind that there is usually no
need to display the pivot chart field buttons. If you need to change the layout or
adjust the data, you can do so in the corresponding pivot table.
Creating multiple pivot charts from a pivot table
In some cases, creating multiple pivot charts from a pivot table might be desirable.
You can create as many pivot charts as you like. Unfortunately, however, doing so
is of limited value. If you make a layout change to one of your pivot charts or to
the pivot table itself, that change will be reflected in all your pivot charts. In other
words, you can’t have multiple pivot charts that display different data summaries.
You can, however, create multiple pivot charts and assign a different chart type
to each one. Figure 9-18 shows four pivot charts created from a pivot table.
Figure 9-18: Four pivot charts from a single pivot table
You can create any number of pivot tables from a single database. Therefore, it
is possible to create multiple pivot charts that display different summaries —
but each different pivot chart must have its own pivot table.
Search JabSto ::




Custom Search