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

Get FREE Advanced Excel Exercises with Solutions!

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 the Pivot Chart in Excel. I hope it may help a little bit for Excel users.

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.

• 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 the pivot table location. I have selected the New Worksheet for the pivot table.
• Then, press the OKÂ button.

• 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.

• 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.

Thus, we can have a Pivot Chart.

How to Refresh Pivot Chart in Excel: 4 Suitable Approaches

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 the Pivot Chart.

Steps:

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

• 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.

Read More:Â How to Edit Pivot Chart in Excel

2. Check Refresh Data When Opening File Option

Checking the Refresh data when opening the file box is another way to refresh the 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.

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

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.

The Pivot Chart will be refreshed.

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.

• 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.

This is another cool way to refresh the pivot chart.

Practice Section

You can practice here for further expertise.

Download Practice Workbook

Conclusion

Thatâ€™s all for the article. In this article, I have tried to explain 4 possible approaches to refresh the 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.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF