Adding and Modifying a Trend Line

  To add a trend line, select a chart item that represents a data fact and on the shortcut menu, select Add Trend Line.

  To modify a trend line:

  1. Double click the trend line.

    The Trend Line Properties dialog box is displayed.

  2. Select the Trend Line tab.

  3. From the Fact drop-down box, select another fact item on which to place a trend line.

  4. Select Bring to front, to move the trend line in front of the data item.

  5. Send to back, to move the trend line behind the data item.

  6. Select the Line Style tab.

    The Trend Line Style dialog box is displayed.

  7. Select any line properties to modify.

    For more information about line properties, see Trend Line Style Properties.

  8. Select the Label Format tab.

    The Trend Line Label Format dialog box is displayed.

  9. Select any label formats to modify,

    For more information about label formats, see Trend Line Label Format Properties .

  10. Click OK.

To delete a trend line, select the trend line and click Delete.