Change the display unit on the value axis

If your chart values consist of large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. For example, if the chart values range from 1,000,000 to 50,000,000, you can display the numbers as 1 to 50 on the axis and show a label that indicates that the units express millions.

  1. Click the value axis you want to change.

  2. On the Format menu, click Selected Axis, and then click the Scale tab.

  3. In the Display units list, click the units you want or type a numeric value.

  4. To show a label that describes the units expressed, select the Show display units label on chart check box.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.