How to Fix Excel Report Charts Not Updating After Query Changes
Question details
Users experience inconsistent chart updates in reports after modifying underlying data queries, where some charts update correctly while others remain unchanged.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Modifying data queries, criteria, or columns that feed into report charts.
- Observed behavior
- Some bar charts update successfully to reflect new query data, while other charts on the same or different reports fail to update.
Before proceeding, ensure that your workbook is set to calculate automatically and check if the underlying query actually returned the expected new rows or columns.
Verify and Update Chart Data Sources
Ensure the chart is properly linked to the dynamic query results table rather than a static range that ignores newly added data.
When queries are modified (such as changing criteria or adding columns), the dimensions of the resulting data table may change. If a chart is mapped to specific static cell references instead of the dynamic query table, it will fail to display the new data.
Click on the specific bar chart or visualization that failed to update.
Navigate to the 'Chart Design' tab on the top ribbon and click on 'Select Data'.
Look at the 'Chart data range' field. If it contains fixed cell references (e.g., $A$1:$C$10), it will not expand when the query grows.
Delete the old range and select the entire dynamic table generated by your query, or manually adjust the range to encompass the newly updated query results. Click 'OK' to apply.

Perform a Full Data Refresh
Force Excel to fetch the latest data from all connected action queries and re-render the charts.
Easily Manage Dynamic Charts and Queries with WPS Spreadsheet
WPS Spreadsheet offers powerful, intuitive data management tools that ensure your charts always reflect the latest query updates. Easily link visualizations to dynamic data sets without worrying about broken references.
- 1. Open your report: Launch WPS Spreadsheet and open your existing data report.
- 2. Manage data queries: Navigate to the 'Data' tab to review, modify, or refresh your underlying query data.
- 3. Update chart links: Right-click the chart that needs updating, select 'Select Data', and verify it points to the correct, updated table range.
- 4. Refresh dynamically: Click 'Refresh All' to instantly sync your visualization with the newest data criteria.

Frequently Asked Questions
Why do my Pivot Charts update but standard charts do not?
Pivot Charts are directly linked to a PivotTable cache, which inherently understands dynamic data expansion upon refreshing. Standard charts rely on specific range definitions; if those ranges are static, the chart will ignore new query data outside that range.
Can changing query criteria break my chart references entirely?
Yes. If changing the query criteria results in the removal of a specific column or data series that the chart was strictly referencing, the chart may display an error or go blank until you manually re-select valid data series.
How can I make my queries refresh automatically when I open the report?
You can automate this by going to the Data tab, clicking 'Queries & Connections', right-clicking your specific query, selecting 'Properties', and checking the box for 'Refresh data when opening the file'.




