Yes. To show Excel chart values in thousands with a K suffix, apply the custom number format 0.0,"K" to the chart axis or data labels. The trailing comma scales the displayed number by 1,000, while the quoted K is added as text; the original worksheet values remain unchanged.
How the K format works
Excel custom number formats can control how a number looks without changing the value stored in a cell or used in calculations. In a format code, a comma immediately after the number placeholders scales the displayed value down by a factor of 1,000. Two scaling commas divide it by 1,000,000. Text such as K or M can then be appended in quotation marks.
For example, if a chart plots 12,500, 0.0,"K" displays it as 12.5K. The chart still plots 12,500, not 12.5. Likewise, a value of 1,250,000 with the same format appears as 1,250.0K. If you want that large value displayed as 1.25M instead, use a millions format such as 0.00,,"M".
The decimal placeholder determines the precision shown. A zero placeholder requires a digit; a hash placeholder shows a digit only when one is needed. Common choices include:
0,"K"displays 12,500 as 13K, rounding to a whole thousand.0.0,"K"displays 12,500 as 12.5K.0.00,"K"displays 12,500 as 12.50K.#,##0.0,"K"uses a thousands separator in the scaled number, so 1,250,000 displays as 1,250.0K.
Format a chart axis in Excel for Windows
For Microsoft Excel for Microsoft 365 on Windows, apply the format directly to the value axis when you want tick marks such as 0K, 5K, and 10K. The chart changes its labels, not the worksheet data.
- Select the chart, then right-click the value axis—the vertical axis in most column charts, or the horizontal axis in a bar chart—and choose Format Axis.
- In the Format Axis pane, expand Number. If Linked to source is selected, clear it so the chart can use its own number format.
- Choose Custom as the category if that choice is shown. Enter
0.0,"K"in Format Code, then select Add. - Close the pane and check that the axis labels are readable and that the displayed scale matches the chart title and context.
Excel may show a different set of controls depending on the chart type and pane layout, but the key is to format the value axis, not the category axis. A category axis contains labels such as months or product names and generally is not where numeric tick values are formatted. If the chart has more than one value axis, format the axis associated with the series you mean to change.
Show K on data labels instead
If you want the values printed beside individual columns, points, or slices to use K, format the data labels rather than—or as well as—the axis. Select the labels, right-click, and choose Format Data Labels. In the pane, open Number, clear Linked to source if necessary, and enter the custom format code, then choose Add.
For instance, a column with a value of 12,500 can have a label of 12.5K while the axis remains 0, 5,000, 10,000, and 15,000. This may be useful when readers need the exact plotted values but the axis should retain conventional full-number intervals. Conversely, formatting only the axis does not necessarily change the labels on each data point. Treat these as separate chart elements and check both.
If the chart’s labels are taken from cells, their display may depend on the label settings and source-cell formatting. If a custom format does not take effect, check whether the labels are showing values from cells rather than the plotted value, and review the Number options for the selected labels. You can also use a helper column with text labels, but those labels will no longer behave as numeric values and may require more maintenance when the data changes.
Choose the right precision and unit
A K suffix makes large values quicker to scan, but the number of decimal places should suit the chart’s purpose. A dashboard summarizing sales by region may be clear with whole thousands, while a chart comparing values close together may need one decimal place. Too many decimals can make labels crowded; too few can conceal meaningful differences.
- Use whole thousands when approximate comparison is enough:
0,"K". - Use one decimal place when differences of hundreds matter:
0.0,"K". - Use millions for very large totals when a K label would produce long numbers:
0.0,,"M". - State the unit clearly in the chart title, axis title, or nearby note—for example, Revenue (thousands of dollars)—especially if readers might mistake 12.5K for 12.5.
Also consider whether all values belong in the same unit. A chart ranging from 400 to 18,000 formatted uniformly in K may display 400 as 0.4K. That is mathematically consistent, but it may be less intuitive than showing 400 as 400 and larger values with K. For a single chart axis, consistency is usually preferable; if mixed presentation is essential, consider separate panels or a carefully designed helper-label approach rather than making the unit ambiguous.
Custom format versus Display Units
Excel also offers a Display units setting in the axis options, with choices such as Thousands and Millions. This changes the axis scale presentation by expressing its units in larger increments. Depending on the chart and settings, Excel may show a display-units label such as Thousands, but that is not necessarily the same as adding K to every tick label.
Use a custom number format when you specifically want labels like 5K or 2.5M. Use Display Units when you want the axis organized in larger unit intervals and an accompanying units label is acceptable. Do not apply both methods without checking the result: scaling through Display Units and also using a scaling comma can make values appear divided twice. For example, a value of 10,000 could be presented as 10 by one method and then incorrectly look like 0.01K if the other scaling is layered on.
Common problems and how to fix them
- The K appears as a date, color code, or formatting error: enter K in quotation marks in the format code, as in
0.0,"K". The quotation marks tell Excel to treat it as literal text. - The numbers still show in full: make sure you selected the numeric value axis or the data labels, not the chart area or category axis. Also check whether Linked to source is overriding the format.
- The values look 1,000 times too small: confirm that the number format has only one scaling comma for thousands. A comma used for grouping is not interchangeable with a trailing scaling comma; placement matters.
- Small values show as 0.0K: the format is scaling every value, including values below 1,000. Use a consistent unit, adjust the chart’s data range, or consider a separate presentation for small values.
- Labels are crowded or overlap: reduce decimal places, show fewer data labels, widen the chart, or use K only on the axis. Changing the format does not automatically make a busy chart readable.
- Negative values are confusing: check that the minus sign remains visible and the unit is clear. A multi-section custom format can define separate appearances for positive, negative, and zero values, but verify the result in the chart before relying on it.
Excel on Mac and Excel for the web
On Excel for Mac, select or Control-click the axis or labels and open the relevant formatting pane; the pane may be arranged differently from Windows, but look for its Number section and the custom format controls. If a right-click menu is unavailable, Control-click is the usual Mac equivalent for opening a contextual menu. The underlying custom format principle is the same.
Excel for the web has chart-formatting capabilities, but available custom-format controls can vary. If the browser version does not offer a way to enter the required chart format code, open the workbook in the desktop Excel app, apply the format there, and save it. When sharing a workbook, check the chart in the version your audience will use so the suffix and units remain clear.
Frequently Asked Questions
What is the Excel format code for thousands with K?
Use 0,"K" for rounded whole thousands or 0.0,"K" for one decimal place. The comma scales the displayed number by 1,000, and the quoted K is a literal suffix.
Does adding K change the chart’s actual values?
No. A custom number format changes only how the axis or data label is displayed. The plotted data and worksheet values stay numeric and retain their original values for calculations.
Can I show K on chart data labels but not on the axis?
Yes. Select and format the data labels separately from the value axis. Applying a format to one chart element does not automatically apply the same format to every other element.
How do I show millions instead of thousands?
Use two scaling commas and a quoted M, such as 0.0,,"M". For example, 1,250,000 displays as 1.3M with one decimal place. Make the unit clear in the chart title or axis title.
Why does Excel show 0.5K for a value of 500?
The format scales every value by 1,000, so 500 becomes 0.5K. That is expected. If it is not suitable for your audience, use full values for that chart or arrange the data into charts with consistent, clearly stated units.
Should I use Display Units or a custom K format?
Use a custom format when you want a K suffix on the tick labels or data labels. Use Display Units when you want the axis expressed in larger increments and a separate units label is acceptable. Avoid combining both scaling methods unless you have checked the resulting values.
Related
- Checklist Template Excel: Set Up, Track, and Reuse Tasks
- Excel Drop-Down Lists: How to Create and Manage Them
- How to Insert a Checkbox in Excel: Steps and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Bubble Chart in Excel: Create, Format, and TroubleshootTo make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric…
- Balance Graph in Physics: Meaning and ExamplesIn physics, a “balance graph” is not one universally defined type of graph; the phrase usually refers either…
- Excel Trendline for All Series: How It WorksNo—Excel does not add one trendline that automatically fits every chart series together. In Microsoft 365 for Windows,…
- No Power Pivot in Excel? How to Find or Enable the Add-inIf Power Pivot is missing in Excel, first check that you are using a supported edition of Excel…
- Excel Line Chart: Ignore Null Values or Show GapsYes. In Excel for Microsoft 365 on Windows, you can control how a line chart handles empty cells:…
- Excel Bubble Chart Different Colors: Set Each SeriesYes. In Excel for Microsoft 365, bubble-chart colors are usually assigned by data series: put each group you…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.