When you create a chart in PowerPoint, the number axis often displays raw values like 1000000 or 5000000. These numbers are hard to read and make your presentation look cluttered. The cause is the default number format, which does not include a thousand separator. This article explains how to apply the thousand separator format to a chart axis in PowerPoint using the Format Axis pane.
Key Takeaways: Formatting Chart Axis With Thousand Separators
- Format Axis pane > Number > Category > Number: Opens the number formatting options for the selected axis.
- Use 1000 Separator (,) checkbox: Adds a comma after every three digits on the axis labels.
- Decimal places control: Set to 0 for whole numbers or 1 or 2 for decimal values on financial charts.
Understanding the Number Format on a Chart Axis
By default, PowerPoint charts inherit the number format from the source data, which may not include any separator. When the axis values exceed 999, the absence of a comma makes the numbers difficult to scan. The Format Axis pane offers a Number section where you can choose a built-in format or create a custom format code. You must select the axis first to see these options. The thousand separator is part of the Number category, not the Currency or Percentage categories.
The Format Axis pane is the same in PowerPoint 2019, 2021, and Microsoft 365. The steps do not change between versions. You do not need to edit the source Excel data to change the axis display. The formatting applies only to the chart in PowerPoint.
Steps to Add a Thousand Separator to the Chart Number Axis
Follow these steps to format the vertical value axis of any chart in PowerPoint.
- Click the chart to select it
Click once on the chart object on your slide. This activates the Chart Tools contextual tabs on the ribbon. - Right-click the vertical axis numbers
Right-click directly on the numbers along the vertical axis. A context menu appears. Do not click the chart area or the plot area. - Select Format Axis from the context menu
Click Format Axis. The Format Axis pane opens on the right side of the PowerPoint window. - Open the Axis Options tab if not already visible
In the Format Axis pane, click the Axis Options icon. It looks like a bar chart with three columns. This icon is at the top of the pane. - Expand the Number section
Scroll down in the pane and click Number to expand that section. You see a drop-down list labeled Category. - Select Number from the Category list
Click the Category drop-down and choose Number. This reveals formatting controls for decimal places and the thousand separator. - Check the Use 1000 Separator (,) box
Below the Decimal places field, you see a checkbox labeled Use 1000 Separator (,). Click the checkbox to enable it. A checkmark appears. - Set Decimal places to 0
In the Decimal places field, type 0 or use the down arrow to reduce the value to 0. This removes any decimal digits from the axis labels. - Close the Format Axis pane
Click the X button at the top-right corner of the pane. The axis now displays numbers with commas: 1,000,000 instead of 1000000.
Formatting the Horizontal Category Axis
The horizontal axis usually contains text categories. If your horizontal axis displays numbers, right-click the horizontal axis numbers instead of the vertical axis. The steps are identical from step 3 onward.
Common Mistakes When Formatting the Number Axis
Thousand Separator Does Not Appear After Checking the Box
If you check the Use 1000 Separator (,) box but the axis labels do not change, verify that the Category is set to Number. The separator option is disabled when the Category is General or Text. Switch to Number first. Also confirm that the axis values are actual numbers and not text strings imported from Excel.
Axis Labels Show Too Many Decimal Places
After selecting Number as the category, the default decimal places is often 2. For large values like 1000000, this displays as 1,000,000.00. Change the Decimal places field to 0 for whole numbers. For financial charts that show dollar amounts, keep 2 decimal places and use the Currency category instead.
Formatting Resets After Editing the Source Data
When you edit the underlying Excel data for the chart, PowerPoint may reset the axis formatting. To prevent this, apply the number format after you have finalized the data. If the format resets, repeat the steps above. You can also save the chart as a chart template to preserve the formatting.
Custom Format Code Overrides the Separator
If you previously entered a custom format code in the Format Code field, the Use 1000 Separator checkbox has no effect. Clear the custom format code by selecting Number from the Category list again. The custom code field resets automatically.
PowerPoint Chart Axis Number Formats: Default vs Thousand Separator
| Item | Default Number Format | Thousand Separator Format |
|---|---|---|
| Display example | 1000000 | 1,000,000 |
| Decimal places | 2 (inherited from data) | User-defined 0 or 2 |
| Category setting | General or Number with no separator | Number with separator enabled |
| Readability for large values | Poor | Good |
| Compatibility with Currency | No | Yes, use Currency category instead |
You can now format any chart axis in PowerPoint to display numbers with thousand separators. This makes your data labels clear and professional without altering the underlying spreadsheet. Next, try applying the same format to data labels inside the chart using the Format Data Labels pane. For even cleaner visuals, set the axis number format to Millions by using a custom format code like #,##0,,”M” in the Format Code field.