Likewise, when you change the order of the categories from left to right, the value labels will flip from the left side to the right side of the chart. Note When you change the order of the values on the value (y) axis from bottom to top, the category labels on the category (x) axis will flip from the bottom to the top of the chart. To reverse the order of the values on the selected axis, select the Values in reverse order check box.Tip This type of scale is useful when the values that are plotted in the chart cover a very large range. To change the value axis to logarithmic, select the Logarithmic scale check box.For example, you can display chart values ranging from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates that the units are expressed in millions. Tip If the chart values are large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. If you want to show a label that describes the units, select the Show display units label on chart check box. To change the units displayed on the value axis, select the units that you want in the Display units list.
To change the interval of tick marks and chart gridlines, type a different number in the Major unit box or Minor unit box.