Chat with us, powered by LiveChat

Refresh a Pivot Chart

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.

Refresh a PivotChart

Just like with a PivotTable, a PivotChart will need to be refreshed if the source data updates.

  1. With the PivotChart selected, click the Refresh button on the Analyze tab.
    Refresh a PivotChart

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.

Use the Field Buttons

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.

  1. Click a field button in the chart.
  2. Turn PivotChart values on or off.
  3. Click OK.
    Use the Field Buttons

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.

Change Chart Layout

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.

  1. With the chart selected, click the Design tab.
  2. Click the Chart Element button.
  3. Select a category.

    A menu appears displaying the available options for the selected category.

  4. Select a chart element to add.
    Change Chart Layout
  5. If needed, modify the new chart element. For example, if you add a chart title, a text box will be added, but you’ll need to populate it with text.

Use Quick Layouts

Built-in chart layouts allow you to quickly adjust the overall layout of your PivotChart with different combinations of titles, labels, and chart orientations.

  1. Click the Quick Layout button.

    A gallery of available layouts appears, based on the chart’s type.

  2. Select a chart layout.
    Use Quick Layouts

The layout is applied.

Change PivotChart Type

You can change the type of chart a PivotChart uses.

  1. Select the PivotChart.
  2. Click the Design tab on the ribbon.
  3. Select a new chart type and click OK.