PivotChart Options in Excel
After you've created a PivotChart, there are some options you should be aware of that control how data is displayed.
Just like with a PivotTable, a PivotChart will need to be refreshed if the source data updates.
The PivotChart updates and pulls in any new or modified source data.
If you have more than one PivotChart in your workbook and you want to update them all at once, instead click the Refresh button’s list arrow and select Refresh All from the menu.
For each field used in a PivotChart, gray field buttons appear in the chart. These allow you to filter the PivotChart based on the values in a given field.
If the buttons are taking up too much space in your chart, turn them off by clicking the Field Buttons button on the Analyze tab.
There are a number of layout options you can add or modify from the Design tab. Make your PivotChart easier to read by adding elements such as titles, gridlines, and legends.
A menu appears displaying the available options for the selected category.
Built-in chart layouts allow you to quickly adjust the overall layout of your PivotChart with different combinations of titles, labels, and chart orientations.
A gallery of available layouts appears, based on the chart’s type.
The layout is applied.
You can change the type of chart a PivotChart uses.
Free to distribute with our compliments; we hope you will consider our paid training.