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.
- Click the value axis you want to change.
- On the Format menu, click Selected Axis, and then click the Scale tab.
- In the Display units list, click the units you want or type a numeric value.
- To show a label that describes the units expressed, select the Show display units label on chart check box.