Chart & Visualization Issues

How to Fix Excel Report Charts Not Updating After Query Changes

Anum MushtaqAnum Mushtaq Nov 2, 2026 871 views

Question details

Users experience inconsistent chart updates in reports after modifying underlying data queries, where some charts update correctly while others remain unchanged.

How to Fix Excel Report Charts Not Updating After Query Changes
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 you start

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.

Solution 1Recommended

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.

1
Select the unresponsive chart

Click on the specific bar chart or visualization that failed to update.

2
Open the Select Data dialog

Navigate to the 'Chart Design' tab on the top ribbon and click on 'Select Data'.

3
Check the data range reference

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.

4
Remap to the query table

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.

Verify and Update Chart Data Sources
Use Excel Tables for dynamic ranges: Formatting your query output as an Official Excel Table (Insert > Table) ensures that charts referencing this table will automatically expand and update as query rows change.
Seamless Data Visualization

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. 1. Open your report: Launch WPS Spreadsheet and open your existing data report.
  2. 2. Manage data queries: Navigate to the 'Data' tab to review, modify, or refresh your underlying query data.
  3. 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. 4. Refresh dynamically: Click 'Refresh All' to instantly sync your visualization with the newest data criteria.
Seamlessly handles dynamic data ranges for automatic chart updates.Fully compatible with Microsoft Excel (.xlsx) formats and complex data structures.Lightweight architecture processes heavy data queries quickly without freezing.Intuitive chart configuration menus make re-linking data sources effortless.
microsoft office alternative - wps office

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