×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×