How to Refresh Pivot Chart in Excel (4 Suitable Approaches)

It does not always happen that you edit something in a place and it gets fixed automatically in all other places. But in Pivot Chart, we actually can do it. We can edit a thing in a dataset and it will get updated in the Pivot Chart by refreshing the Pivot Chart. In this article, I am going to explain 4 possible approaches to refresh Pivot Chart in Excel. I hope it may help a little bit for Excel users.


Download Practice Workbook


Creating Excel Pivot Chart

In order to explain the refresh of the Pivot Chart in Excel, first of all, I am going to explain how to make a Pivot Chart. The steps are listed below.

Steps:

  • Firstly, gather a dataset to create a Pivot Table which leads to a Pivot Chart. I have gathered data and decorated them in Name, Gender, and Height (cm) columns.

How to Refresh Pivot Chart in Excel

  • Next, select all the data (i.e. B4:D17).
  • Then, go to the Insert tab.
  • Click on Pivot Table from the ribbon.
  • Pick the From Table/Range option.

  • Choose pivot table location. I have selected the New Worksheet for the pivot table.
  • Then, press the OK button.

How to Refresh Pivot Chart in Excel

  • From the Pivot Table Fields, pick rows and values. I have picked Name as Rows and Height as Values.

Then, we will have a default Pivot Table.

How to Refresh Pivot Chart in Excel

  • We can edit the table according to our choice.
  • Followingly, select all the cells in the Pivot Table.
  • Go to the Insert tab.
  • Choose Recommended Charts from the ribbon.

An Insert Chart wizard will appear.

  • Select your chart type.
  • Finally, press OK to have the Pivot Chart.

How to Refresh Pivot Chart in Excel

Thus, we can have a Pivot Chart.

Read More: Difference Between Pivot Table and Pivot Chart in Excel


4 Suitable Approaches to Refresh Pivot Chart in Excel

1. Refresh Manually from PivotChart Analyze

We can manually refresh the Pivot Chart from the PivotChart Analyze tab. It is the easiest way to refresh Pivot Chart.

Steps:

  • Update your dataset. In my case, I have added a whole new row with detailed information.

How to Refresh Pivot Chart in Excel

  • Then, go to the PivotTable Analyze tab.
  • Click on Refresh from the ribbon.

We will have the updated values both in the Pivot Table and Pivot Chart.

How to Refresh Pivot Chart in Excel

Read More: How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart


2. Check Refresh Data When Opening File Option

Checking the Refresh data when opening the file is another way to refresh Pivot Chart.

Steps:

  • Right-click on the Pivot Table.
  • Select PivotTable Options…

A Pivot Table Options box will appear.

  • Click on the Data tab.
  • Now, check the Refresh data when opening the file box.

How to Refresh Pivot Chart in Excel

We will have the refreshed Pivot Chart when opening the file.

Read More: How to Use Pivot Chart in Excel (8 Suitable Examples)


3. Right-Click on Mouse to Refresh Pivot Chart

Another simple way to refresh Pivot Chart is to choose the Refresh option after right-clicking on the Pivot Table.

Steps:

  • Put the cursor on the Pivot Table.
  • Right-click on the mouse.
  • Select Refresh from the available options.

How to Refresh Pivot Chart in Excel

The Pivot Chart will be refreshed.

Read More: Types of Pivot Charts in Excel (7 Most Popular)


4. Using VBA to Refresh Pivot Chart

Using VBA is the smartest way to refresh Pivot Chart.

Steps:

  • Firstly, go to the Developer tab.
  • Then, pick Visual Basic from the ribbon.

How to Refresh Pivot Chart in Excel

  • Double click on the Sheet to have the space to write the code.

  • Insert the following code.
Sub RefreshPivotCharts()
     ActiveWorkbook.RefreshAll
End Sub

Here, I have a Sub_procedure named RefreshPivotCharts. I have applied ActiveWorkbook.RefreshAll properties to automatically update the Pivot Chart.

  • Click on the Run or F5 button.

How to Refresh Pivot Chart in Excel

This is another cool way to refresh pivot chart.


Practice Section

You can practice here for further expertise.

How to Refresh Pivot Chart in Excel


Conclusion

That’s all for the article. In this article, I have tried to explain 4 possible approaches to refresh Pivot Chart in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo