# How to auto-refresh Pie Chart in Excel when data is updated by Process Studio?

**URL:** <https://community.automationedge.com/t/how-to-auto-refresh-pie-chart-in-excel-when-data-is-updated-by-process-studio/17529>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [February 12, 2026, 6:19am UTC](https://community.automationedge.com/t/how-to-auto-refresh-pie-chart-in-excel-when-data-is-updated-by-process-studio/17529 "2026-02-12T06:19:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ankitraii](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/ankitraii/32/2076_2.png) [@ankitraii](https://community.automationedge.com/u/ankitraii)\
**Post date:** [February 12, 2026, 6:19am UTC](https://community.automationedge.com/t/how-to-auto-refresh-pie-chart-in-excel-when-data-is-updated-by-process-studio/17529/1 "2026-02-12T06:19:29Z")

</div>

I am using AutomationEdge Process Studio to write/update data into an Excel file using a template. In the same Excel file, I have created a Pie Chart based on this data.

Currently, whenever Process Studio adds new rows or updates the data, I have to manually refresh or reselect the data range for the Pie Chart in Excel.

I want the Pie Chart to **refresh/update automatically** whenever Process Studio updates the Excel data.

Please suggest the recommended solution for this use case.

---

<div class="post-metadata">

**Author:** ![AETrainings](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@AETrainings](https://community.automationedge.com/u/AETrainings)\
**Post date:** [February 12, 2026, 7:41am UTC](https://community.automationedge.com/t/how-to-auto-refresh-pie-chart-in-excel-when-data-is-updated-by-process-studio/17529/2 "2026-02-12T07:41:48Z")

</div>

When you create a Pivot Chart, Excel automatically creates an associated Pivot Table in the sheet (or in a new sheet). The chart is always linked to that Pivot Table.

Therefore, even if you are mainly using a Pivot Chart, the actual data refresh happens at the Pivot Table level.

Recommended approach:

1. Open the Pivot template file.

2. Locate the automatically created Pivot Table (linked to the Pivot Chart).

3. Right-click on the Pivot Table.

4. Select **PivotTable Options**.

5. Go to the **Data** tab.

6. Enable **“Refresh data when opening the file.”**

7. Click **OK** and save the template.