Chart & Visualization Issues

Fix Missing or Disabled Excel Charts After the Office 2016 Update

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Restore Excel chart options and existing charts that disappeared after an Office update.

Product
Microsoft Excel in Office 2016
Device & OS
Windows; version not provided
Scenario
An Office installation was updated from version 1902 to version 1903.
Observed behavior
Chart options are disabled and existing charts are not visible on computers running version 1903, while systems on version 1902 are unaffected.
Before you start

In Excel, open File > Account to check the Office version, update channel, and installation type. The command-line method below applies to Click-to-Run installations and requires administrator access; contact your IT administrator if Office updates are managed by your organization.

Solution 1Recommended

Change the Office update channel and run an update

Use this reported fix when version 1903 disables Excel charts and Office is on the Monthly update channel.

The original fix switched Office from the Monthly channel to the Broad channel and installed an update. Channel names and availability have changed since Office 2016, so this legacy command may not work with your current configuration.

1
Check the update channel

In Excel, select File > Account and review the Office version and update channel under Product Information. If your organization controls the channel, ask its administrator before changing it.

2
Open an elevated Command Prompt

Open the Windows Start menu, search for Command Prompt, select Run as administrator, and approve the prompt.

3
Open the Click-to-Run folder

Enter `cd /d "C:\Program Files\Common Files\Microsoft Shared\ClickToRun"` and press Enter. If the folder is not found, check whether it is under `C:\Program Files (x86)\Common Files\Microsoft Shared\ClickToRun` instead.

4
Change the channel and update Office

Run `OfficeC2RClient.exe /changesetting Channel=Broad`, then run `OfficeC2RClient.exe /update user`. Allow the Office update to complete.

5
Restart and check the charts

Restart the computer, open the affected workbook in Excel, and check whether existing charts appear and Insert > Charts options are available.

If the channel change is unavailable: Do not assume Broad is supported on a current installation. Check Microsoft’s current update-channel guidance or contact your Office administrator for a supported channel and update method.
Free Microsoft Office alternative

Open and edit spreadsheet charts with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format support for moving between applications. WPS Spreadsheets can open workbooks and work with charts, although complex chart formatting may vary.

Open and work with spreadsheet charts in WPS SpreadsheetsSupports Microsoft Excel formats including XLS and XLSXFamiliar spreadsheet interface for an easier transition from ExcelFree, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

How do I check which Office version and update channel I have?

In Excel, select File > Account and look under Product Information. The displayed version and channel details depend on your Office installation.

Why are my Excel chart options disabled after version 1903?

The reported issue appeared after the version 1903 update, while computers on version 1902 were unaffected. An Office update or channel change resolved the issue in the reported case, but other causes are possible.

Can I use the Broad channel command on every Office installation?

No. The command was reported for a Click-to-Run installation, and Broad is a legacy channel name. Availability and organizational update policies can prevent the change.

What should I do if updating Office does not restore my charts?

Try repairing Office from Windows Settings > Apps > Microsoft Office > Modify, then reopen the workbook. If charts are still missing, contact Microsoft Support or your Office administrator.