Remove an Extra Comma from an Excel Data Callout
Question details
Display an Excel chart point value without the extra comma in a 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.
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.
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.
Click the chart, select the data callout label or label series, and press Delete.
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.
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.

Use a text box linked to the point value
Use a linked text box when you want to position a value manually and control its appearance.
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.

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.




