Show All

Change a chart value axis

1. Click the value axis you want to change.
2. On the Format menu, click Selected Axis, and then click the Scale tab.
3. Do one of the following:

   Change the number at which the value axis starts and ends

   Enter a different number in the Minimum box or the Maximum box.

   Change the interval of tick marks and gridlines

   Enter a different number in the Major unit box or Minor unit box.

   Change the units displayed 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. In the Display units list, click the units you want or type a numeric value.
   2. To show a label that describes the units expressed, select the Show display units label on chart check box.

   Change the value axis to logarithmic

   Select the Logarithmic scale check box.

   Reverse the order of values

   To reverse values so that you can flip bars or columns or other data markers, select the Values in reverse order check box.

   Change where the category (x) axis crosses the value axis

   Do one of the following:

   To have the category (x) axis cross at a number on the value axis that you specify, enter the number in the Category X crosses at box.

   To have the x-axis cross the value axis at the highest value, select the Category (X) axis crosses at maximum value check box. When selected, the Category (X) axis crosses at maximum value check box overrides the setting in the Category X crosses at box.