Chart & Visualization Issues

How to Fix Excel Chart Data Labels Showing Question Marks

Rana Garcia Oct 9, 2026 869 views

Question details

The user needs to resolve an issue where chart data labels display question marks instead of the actual data values.

How to Fix Excel Chart Data Labels Showing Question Marks

Product: Excel
Device & OS: not provided
Scenario: Viewing or editing a chart in a spreadsheet where data labels are actively enabled to show values.
Observed behavior: The data labels on the chart render as question marks instead of displaying the correct numerical values, often due to formatting or style corruption.

Before you start

Ensure that the source data for your chart contains valid numbers and no hidden characters. It is also helpful to save a quick backup of your spreadsheet before applying global formatting resets.

Solution 1Recommended

Reset the Chart to Match Style

Use the built-in reset feature to clear corrupted custom formatting and restore the default chart style, which often resolves the question mark issue immediately.

Applying various custom styles or pasting charts from other documents can sometimes corrupt the underlying format codes. Resetting the chart's style removes these conflicts without affecting the actual data.

Select the chart

Click anywhere on the problematic chart to select it. This action will reveal the Chart tools on the top ribbon.

Navigate to Chart Design

Click on the 'Chart Design' tab located in the top ribbon menu.

Apply the style reset

Click on the 'Reset to Match Style' button to clear custom formatting and restore the default appearance. The data label numbers should now display correctly.

Quick Fix: Users frequently report that this simple style reset is the fastest way to resolve the question mark error without having to delete and recreate the chart from scratch.

Solution 2

Adjust the Number Format of Data Labels

Manually correct the number formatting of the data labels if they are set to an incompatible or custom format that causes them to display improperly.

Create and Format Charts Easily with WPS Spreadsheet

WPS Office provides a seamless and user-friendly experience for creating, formatting, and managing spreadsheet charts. If you frequently encounter formatting glitches with data visualization, try WPS Spreadsheet to handle your charts accurately and effortlessly.

1. Open your file in WPS: Launch WPS Office and open your existing spreadsheet containing the chart data.
2. Insert a new chart: Highlight your data, go to the 'Insert' tab, and choose your preferred chart type to instantly visualize the numbers.
3. Add data labels: Click on the chart, use the 'Chart Elements' plus icon, and check 'Data Labels' to display precise values on your chart.
4. Format labels effortlessly: Double-click the data labels to open a clean formatting pane where you can easily adjust the number format, fonts, and colors.

Highly compatible with Microsoft Excel (.xlsx) file formatsIntuitive chart design and hassle-free data label formatting toolsFree to use for everyday data visualization and analysis tasksLightweight application that runs smoothly on almost any device

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel data labels suddenly turn into question marks?

This usually happens when the applied number format becomes corrupted, or an unsupported custom font or style is applied to the chart labels. Resetting the chart style clears these conflicts.

Will resetting the chart style delete my actual data?

No, resetting the chart style only restores the visual formatting (like colors, fonts, and label formats) to the default theme. Your original data in the spreadsheet remains completely untouched.

Can I fix this if the source data itself displays question marks?

If the source cells contain question marks due to a formula error or file encoding issue, you must fix the data in the cells first. The data labels on the chart will automatically update once the source cells display actual numbers.

Does recreating the chart prevent this issue from happening again?

Recreating the chart will fix the current question marks by generating fresh default styles, but it is often unnecessary and time-consuming. Adjusting the label format or using 'Reset to Match Style' is a much faster and equally effective solution.

Excel & Data Problems