Chart & Visualization Issues

Fix Excel 2016 Chart Corruption and Workbook Save Errors

Phi Hung VoPhi Hung Vo Nov 22, 2026 868 views

Question details

The user needs to resolve incorrect chart values, blank buttons, and workbook save errors in Excel 2016.

Fix Excel 2016 Chart Corruption and Workbook Save Errors
Product
Microsoft Excel 2016
Device & OS
Windows; version not provided
Scenario
Working with charts and saving workbooks in Excel 2016.
Observed behavior
Chart data and buttons display incorrectly, and saving may fail. The same symptoms can occur in a newly created workbook.
Before you start

Note your current Windows regional format and country settings so you can restore them if needed. Close Excel before changing regional settings, and have a small sample dataset ready for testing.

Solution 1Recommended

Check and change the Windows regional format

Try this when chart and save problems also occur in new workbooks and may be related to regional settings.

1
Open regional settings

Open Windows Settings and go to Time & Language > Region, or Time & Language > Language & region, depending on your Windows version.

2
Review the format and country

Check Country or region and Regional format. Choose a regional format appropriate for your language and country; in the reported case, changing the format from English (Sweden) to Swedish (Sweden) resolved the issue.

3
Restart Excel and test

Reopen Excel 2016, create a chart from sample data, and use File > Save As to save the workbook. Check whether the chart values and buttons display correctly.

Check and change the Windows regional format
Regional formats affect other applications: Changing the regional format can alter date, number, and decimal separator displays across Windows. Restore your previous setting if the change does not help or causes unwanted formatting.
Free Microsoft Office alternative

Work with Excel charts in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks and continue working with spreadsheets as you transition from Microsoft Office; it does not repair Excel 2016 itself.

Create and edit spreadsheet charts in WPS SpreadsheetsOpen and save compatible Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office suite
QA img-9

Frequently Asked Questions

Does a corrupted chart always mean the workbook is damaged?

No. Create a blank workbook through File > New and insert a chart with sample data. If the same issue appears there, regional settings or the Office installation may be involved.

Which regional setting resolved the reported Excel 2016 issue?

Changing the Windows regional format from English (Sweden) to Swedish (Sweden) resolved the reported chart and save problems. Open Settings > Time & Language > Region or Language & region to review your settings.

Will changing the regional format affect other programs?

It can change how dates, numbers, and decimal separators appear across Windows applications. Note your original format before changing it so you can restore it if necessary.

How do I repair Office 2016 if new workbooks have the same problem?

Close Office apps, then open Control Panel > Programs > Programs and Features. Select Microsoft Office 2016, choose Change, and run Quick Repair or Online Repair if available.