Adding trendlines
After you make a chart, you can insert trendlines in it. A trendline shows the trend of the data with a line. If you use trendlines, you can predict the values even in the range where the date is not yet inputted, and therefore they are often used for the stock price analysis or sales analysis. The trendline is generally used to predict the long term change, rather than the short term change. Trendlines can be added to the unstacked column type, unstacked line graph type, Scatter type, etc. For the detailed information about trendlines, refer to the Trendlines tab of the Chart Properties dialog box.
To insert a trendline into the chart, double-click the relevant chart, or in the shortcut menu, select Chart properties. In the Trendlines tab of the Chart Properties dialog box, specify the trendlines.
Insert a second polynominal trendline into the chart
- Double-click the chart, or in the shortcut menu, select Chart Properties.
- Select the Trendlines tab in the Chart Properties dialog box, and select the series in the list box of Select series.
- Select a trend line type in the list box in the Trendline type, and then click Add. To remove a trendline, select the trendline in the Displayed trendlines, and then press Remove.
- If you wish to show the data series and the type of each trendline in the legend, select Show trendlines in legend.
- In the Chart preview, confirm the chart appearance, and click OK.