Chart & Visualization Issues

Fix Excel Box and Whisker Charts That Do Not Update

Maira MehtabMaira Mehtab Nov 20, 2026 870 views

Question details

Fix an Excel Box and Whisker chart that does not update when its source range changes.

Fix an Excel Box and Whisker Chart That Does Not Update
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.
Before you start

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.

Solution 1Recommended

Update or Repair Microsoft Office

Use this approach to address an outdated or damaged Office installation that may affect chart updates.

1
Check for Office 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.

2
Test the chart

Reopen the workbook, change the data or the cell that controls the OFFSET range, and check whether the Box and Whisker chart updates.

3
Repair Office if needed

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.

4
Retest the workbook

Open the workbook in Excel again and change the chart's source data to see whether the chart now updates.

Update or Repair Microsoft Office
Support availability: Windows 7 and Office 2016 are out of support, so current updates and repair options may be limited. Consider moving to supported versions if the issue persists.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet data and charts in a familiar interfaceUse a free, lightweight Office alternative for everyday workMove existing Excel workbooks to WPS without recreating their data
microsoft office alternative - wps office

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.