You can customize your view of the data by expanding and compressing the height (amplitude) of the trend. For example, you can compress a trend that has gone off of the Y scale limits. You can also change the percentage by which the trend is expanded or compressed.
- Select the trend that you want to expand or compress vertically.
- Click to reduce the height of the trend.
- Click to increase the height of the trend.
To change the amount by which the trend is expanded or compressed,
click
. Enter a number
between 0 and 100 and click
OK. Or click
to change the amount.
Occasionally high or low data points may fall out of view of the Y scale limits. To reposition the trend so that all data points are visible within the Y scale limits, click a data point (the cursor turns into a hand when the data point is selected), drag the trend vertically, and then release the mouse button when all data points are visible. Click , select the Chart Preferences tab, and click Mark Data Points to show data points.