Fix Excel Box and Whisker Charts That Do Not Update
Question details
Fix an Excel Box and Whisker chart that does not update when its source range changes.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows 7 Enterprise, 32-bit Excel
- Scenario
- A Box and Whisker chart uses a changing source range defined with an OFFSET formula.
- Observed behavior
- The chart does not update automatically, but manually updating its source range works. No error message appears.
In Excel, check Formulas > Calculation Options and confirm that Automatic is selected. Review the chart's named range under Formulas > Name Manager and verify that its OFFSET formula refers to the intended cells.
Update or Repair Microsoft Office
Use this approach to address an outdated or damaged Office installation that may affect chart updates.
In Excel, open File > Account > Update Options > Update Now. If Update Options is unavailable, check with your administrator about how Office updates are managed.
Reopen the workbook, change the data or the cell that controls the OFFSET range, and check whether the Box and Whisker chart updates.
On Windows, open Control Panel > Programs > Programs and Features, select Microsoft Office, and choose Change. Choose Quick Repair or Repair, depending on the installation, and follow the prompts. If Quick Repair does not help and Online Repair is available, try Online Repair.
Open the workbook in Excel again and change the chart's source data to see whether the chart now updates.

Reset the Chart's Source Range Manually
Use this workaround when the dynamic named range changes but the chart does not reflect the new range.
Work With Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday workbook tasks between applications. It does not repair Microsoft Excel, and chart compatibility should be checked when opening a workbook.

Frequently Asked Questions
Why does my Box and Whisker chart not update when the OFFSET range changes?
The chart may not pick up changes to a dynamic named range, or the Office installation may need attention. Check the formula under Formulas > Name Manager, update or repair Office, and reset the chart's source range if necessary.
How do I check whether Excel is calculating automatically?
Open Formulas > Calculation Options and select Automatic. If it is already selected and the chart still does not update, try resetting the chart source under Chart Design > Select Data.
What can I do if Update Options is missing in Excel?
Open File > Account and check how Office is licensed. Some installations are updated through an organization's management tools, so contact your administrator if Update Options is not available.
Will manually selecting the source range fix the chart permanently?
Not necessarily. Selecting the current cells through Chart Design > Select Data can update the chart, but a fixed range may need to be changed again when rows are added or removed.




