Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Components That Show Trending
Figure 8-4: Vertical scales should always start at zero.
To adjust the scale of your vertical axis, follow these simple steps:
1. Right-click the vertical axis and choose Format Axis.
The Format Axis dialog box appears. (See Figure 8-5.)
2. In the Format Axis dialog box, expand the Axis Options section and set the Minimum value
3. (Optional) You can set the Major Unit value to half the Maximum value in your data.
This ensures that your trend line is placed in the middle of your chart.
4. Click the Close button (the x) to apply your changes.
Figure 8-5: Always set the Minimum value of your vertical axis to zero.