The number and range of values appearing on the y-axis depends on several factors, including the smallest series value, the largest series value, the height of the chart, and the amount of vertical space chart items occupy. Compare the charts in Figure 6-33. Both charts present the same data, but the number of y-axis values are different. In the chart on the left, the y-axis displays three values, ranging from 0K to 200K. In the chart on the right, the y-axis displays two values ranging from 0K to 200K. Both charts have the same height value, so in these examples, the different number of y-axis values is a result of the different amounts of space the x-axis labels occupy. The y-axis values-formatting options are not available for doughnut and pie charts.
You can control the range of values that appear on the y-axis. In Chart Builder—Format, in Values (Y Axis), you can set the following options:
|
Minimum Value. Type a number that represents the lowest value to display on the y-axis. This number appears at the bottom of the y-axis.
|
|
|
Maximum Value. Type a number that represents the highest value to display on the y-axis. This number appears at the top of the y-axis.
|
|
|
Auto Step. Deselect Auto Step, and type a number that represents the increment between each value.
|
