×
英语
很抱歉。本文没有你的语言版本。

Add a trendline to a data series

  1. Click the data series to which you want to add a trendline or moving average.

  2. On the Chart menu, click Add Trendline.

  3. On the Type tab, click the type of regression trendline or moving average you want.

    If you select Polynomial, enter in the Order box the highest power for the independent variable.

    If you select Moving Average, enter in the Period box the number of periods to be used to calculate the moving average.

Note: 

  • The Based on series box lists all the data series in the chart that support trendlines. To add a trendline to another series, click the name in the box, and then select the options you want.

  • If you add a moving average to an xy (scatter) chart, the moving average is based on the order of the x values plotted in the chart. To get the result you want, you might need to sort the x values before you add a moving average.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×