The number and range of values appearing on the
y‑axis depend 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.
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.