How to Format Axis Labels as Millions

Format AxisCustom Number Format

When working with large numbers such as millions or billions, the axis can take much space in a chart. To change million to a short version (e.g., 1,000,000 to 1 million or 1M), please follow the steps below. For example, we have the data table below.

1. Format Axis

Step 1: To make a chart (e.g., column chart) with the first two columns in the table below, or please check how to make a column chart;

Step 2: To change Y-Axis in the chart to unit "million": right-click the Y-Axis, then click "Format Axis" in the dialog box;

Step 3: In the "Format Axis" window, select "Millions" as the Display units. Please check the box in front to show display units label on chart.

Step 4: The following is the resulting chart.

Note: you can change to other "display unit" such as Hundreds, Thousands, Millions, Billions or Trillions.

2. Custom number format (e.g., 1,000,000 to 1M).

Step 1: Right click Y Axis, then click "Format Axis";

Step 2: In the "Format Axis" window, type format code [>999999] #,,"M";#0 in the number section, then click "Add";

Step 3: Here is the final chart.

Download Example

Leave a Reply