Chart & Visualization Issues

Remove an Extra Comma from an Excel Data Callout

Steven ParkerSteven Parker Nov 20, 2026 869 views

Question details

Display an Excel chart point value without the extra comma in a data callout.

Remove an Extra Comma from an Excel Data Callout
Product
Microsoft Excel
Device & OS
not provided
Scenario
A chart uses a data callout to show a point value without descriptive label text.
Observed behavior
The callout displays an extra comma before the value because of its built-in formatting.
Before you start

Select the affected chart and check the label options to confirm which components are displayed. If the comma appears only in the callout, changing the number format may not remove it.

Solution 1Recommended

Replace the callout with a standard data label

Use a standard label when you only need to show the point value without the callout's built-in punctuation.

The extra comma is a limitation of the built-in data callout format and cannot normally be removed through number formatting.

1
Remove the callout

Click the chart, select the data callout label or label series, and press Delete.

2
Add a standard label

Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a position such as Right or Above instead of Data Callout.

3
Show only the value

Right-click the new label and choose Format Data Labels. Under Label Options, select Value or Y Value and clear other label components that you do not need.

Replace the callout with a standard data label
Appearance will change: A standard data label does not have the same callout shape. Label options and positions can vary by chart type.
Free Microsoft Office alternative

Work with chart labels in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files in WPS Spreadsheets to continue working with charts and labels, though it does not change Excel's built-in callout behavior.

Edit spreadsheet charts and data labels in WPS SpreadsheetsOpen and save Microsoft Excel XLSX files for easier migrationUse a familiar interface for everyday spreadsheet tasksWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is there a comma before the value in my Excel data callout?

The comma can be part of Excel's built-in data callout formatting when no descriptive label text is present. It is not necessarily caused by the cell's number format.

Can I remove the comma by changing the number format?

Not normally. If the comma comes from the callout format, use Chart Design > Add Chart Element > Data Labels to choose a standard label position instead.

How do I show only the Y value on a chart?

Right-click a standard data label, choose Format Data Labels, and under Label Options select Y Value or Value. Clear the other label components you do not need.

Can a text box update when the source value changes?

Yes. Select the text box border, click the formula bar, enter a reference to the source cell, and press Enter. The displayed value updates with the linked cell, but the box remains manually positioned.

How can I request a callout without the extra comma?

In Excel, use File > Feedback, if available in your version, to send Microsoft a suggestion for a callout that displays only the Y value.