Excel Chart Axis in Millions: Format Values Clearly

To show an Excel chart axis in millions, select the axis, open Format Axis, and either choose Millions under Axis Options > Display units or apply a custom number format such as #,##0,,"M". The display-units setting scales the axis labels; the custom format keeps the underlying chart values intact while presenting labels in a shorter form.

Quick method: set display units to millions

In Excel for Microsoft 365 on Windows, click the chart’s value axis—the vertical axis in most column charts or the horizontal axis in a bar chart. Right-click it and choose Format Axis. In the pane, open Axis Options, find Display units, and select Millions. Excel then expresses the axis scale in millions instead of showing every digit.

For example, an axis that would otherwise show 1,000,000, 2,000,000, and 3,000,000 can show 1, 2, and 3 after the display unit is set to Millions. If available in the pane, Show display units label on chart adds a label such as “Millions” to clarify the scale. This option is useful when a plain 1 or 2 could be mistaken for a count rather than a count of millions.

This changes how the chart’s axis is presented, not the numbers in the worksheet. A source value of 2,500,000 remains 2,500,000 in its cell, and the chart still plots that value at the same position. It is a display choice, not a calculation or data conversion.

Use a custom number format to show an M suffix

If you want labels such as 1M, 2M, and 2.5M rather than 1, 2, and 2.5, use a custom number format. Select the value axis, open Format Axis, then expand Number. If Linked to source is selected, clear it when you want to give the axis its own format. Enter a format in Format Code and choose Add.

For whole millions with an M suffix, enter #,##0,,"M". For one decimal place, use #,##0.0,,"M". A value of 2,500,000 is displayed as 3M with the first format because it rounds to a whole million, and as 2.5M with the second. The underlying value and plotted location are unchanged.

The commas after the final digit placeholder do the scaling: each trailing comma divides the displayed number by 1,000, so two commas divide it by 1,000,000. The commas inside #,##0 are different; they group thousands in the displayed number. Quotation marks make M a literal character instead of a format instruction.

Choose the right format for your chart

There is no single best way to label every chart in millions. Choose based on what readers need to understand quickly and how much room the axis has. These examples assume the axis values are in the original units, not already converted to millions:

1, 2, 3 with a separate “Millions” label: Choose Display units > Millions. This is compact and makes the scale explicit when the display-units label is visible.
1M, 2M, 3M: Apply #,##0,,"M". This is familiar in dashboards, though a chart title, axis title, or note should explain the abbreviation if the audience may not know it.
1.5M, 2.0M, 2.5M: Apply #,##0.0,,"M". One decimal place is useful when differences smaller than a million matter.
$1.5M, $2.0M: Apply $#,##0.0,,"M" for dollar-denominated values. Check that the currency symbol is appropriate for the data and the audience.

More decimal places add detail but can make labels crowded. If the chart compares broad totals, whole millions may be enough. If it compares values close together, one decimal place—or a different unit such as thousands—may make the differences easier to see.

Keep the axis scale and number format working together

Display units and custom number formats solve related but distinct problems. Display units tell Excel to show the axis in a selected unit, such as thousands or millions. A custom format controls how the labels look, including decimal places, separators, currency symbols, and suffixes. You can use a custom format to add an M, but you generally should not also set Display units to Millions unless you have confirmed the result. Applying both scaling methods can make labels misleading or scale them twice.

For a straightforward “millions” axis, choose one approach: select Millions in Display units, or keep the axis in its normal scale and use a format with two trailing commas. If you combine them for a special layout, inspect several known tick values and compare them with the source data before sharing the chart.

Axis bounds and major units are separate controls. In Axis Options, you can set minimum and maximum bounds and the major unit—the interval between major tick marks. For instance, a chart spanning 0 to 8,000,000 with a major unit of 2,000,000 can have ticks at 0, 2, 4, 6, and 8 when shown in millions. Setting the display format does not automatically choose the most informative range or interval.

Format the axis, not the data labels by mistake

Charts contain several kinds of text that can look similar but have independent formatting. Axis labels sit along the chart’s scale. Data labels appear next to individual bars, points, or slices. A chart title, axis title, legend, and worksheet cells are separate too. Selecting the wrong element can make it seem as though Excel ignored a format.

Click directly on the axis tick labels before opening Format Axis. If you want values printed on each bar, select the data labels and format those separately. Formatting the value axis does not necessarily change data labels, and formatting a worksheet column does not guarantee that every chart component will use the same format. For a chart that needs both, format the axis and the data labels individually, then check that their units agree.

Axis titles can provide context such as “Revenue (USD millions)” or “Population (millions).” This is often clearer than relying on a short M suffix alone, particularly when a chart may be copied into a presentation without the surrounding worksheet.

Common problems and how to fix them

The labels show 2,500,000 instead of 2.5M: Confirm that the value axis is selected and that the custom code has two trailing commas. A single trailing comma scales by thousands, not millions.
The axis shows 2.5 but no M: The values may be scaled correctly, but the suffix is missing. Use a format such as #,##0.0,,"M", or show a separate display-units label.
The chart appears to scale values twice: Check whether Display units is set to Millions while the number format also has two scaling commas. Return to one scaling method and verify the labels against the source values.
Some labels lose the suffix or show unexpected decimals: Check the custom format and whether another axis or label element was selected. If Linked to source is enabled, the axis may inherit the source formatting.
Small values round to 0M: Increase the decimal places or use thousands instead. A format with one decimal place distinguishes values down to tenths of a million; it cannot preserve every small difference.
The chart still looks misleading: Check the axis minimum, maximum, and major unit. A clear number format cannot compensate for an axis range that hides important variation or exaggerates it.

Excel on Mac and Excel for the web

In Excel for Mac, select the chart axis and open the formatting controls for that axis; the pane and available chart options can vary somewhat by Excel version. Look for the axis options and the number-format controls rather than assuming the Windows layout is identical. The same underlying idea applies: display units scale the axis presentation, while a custom number format controls how its tick labels are written.

Excel for the web supports many chart-formatting tasks, but its controls may not expose every desktop option in the same way. If you cannot find Display units or the custom format-code field in the browser, open the workbook in the Excel desktop app and make the change there. After editing in either version, review the chart at its intended size; a format that fits on a wide desktop chart may crowd labels in a narrow view.

Frequently Asked Questions

How do I show millions on the vertical axis in Excel?
Select the vertical axis, choose Format Axis, and set Axis Options > Display units to Millions. To show an M after each tick value, use a custom format such as #,##0,,"M" instead.

What custom format displays 2.5 million as 2.5M?
Use #,##0.0,,"M" on the chart’s value axis. The two trailing commas scale the displayed value to millions, the 0.0 requests one decimal place, and the quoted M is displayed literally.

Does formatting an axis in millions change my worksheet numbers?
No. Axis display units and number formats change the chart’s presentation. They do not divide the source cells or change the values used by the chart.

Can I show millions with a dollar sign?
Yes. For example, apply $#,##0.0,,"M" to show a value such as 2,500,000 as $2.5M. Use the right currency symbol and explain the units if the chart will be read without its original context.

Why does Excel show 0M for a value below one million?
A whole-million format rounds small values to the nearest million, so values below roughly half a million can display as 0M. Add decimal places, choose thousands, or use full values if that precision matters.

Check the chart before sharing it

After formatting, compare at least one axis label with a known source value: 2,000,000 should read 2 with a Millions display unit or 2M with the corresponding custom format. Confirm that the chart title or axis title states what the numbers represent, that the axis range is appropriate, and that labels remain readable at the final size. Those checks help prevent a compact label from being mistaken for a changed value or an unexplained unit.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.