通过向现有数据添加趋势线,可以轻松确定从现有数据中出现的趋势。Microsoft Excel具有此工具。因此,它可以显示预测数据的一般模式和总体方向。让我们引导您完成在 Office Excel 中添加趋势(add a Trendline in Office Excel)线的步骤。
在 Excel 工作表中添加趋势线
Excel中的趋势线是显示总体趋势(向上/向下或增加/下降)的线。因此,它可以帮助快速解释数据。Excel中的趋势线可以添加到各种图表中,包括条形图、折线图、散点图等。
让我们快速让您完成以下过程 -
- 创建图表
- 添加趋势线
- 格式化趋势线
- 添加移动平均线。
请(Please)注意,本文中的步骤适用于Office 2019/2016/2013版本。
1]创建图表
输入(Enter)要为其创建图表的数据。
接下来,选择数据并选择“I nsert ”选项卡。
滚动“推荐图表(Recommended Charts)”类别并单击任何图表以预览数据(如果您没有看到您喜欢的图表,请单击所有图表以查看所有可用的图表类型)。
2]添加趋势线
创建图表后,选择它,然后点击图表旁边可见的“+”图标。
向下滚动(Scroll)选项列表并选择“趋势线(Trendline)”。
单击侧箭头以查看更多选项并选择所需选项。
请(Please)注意,仅当您选择具有多个数据系列的图表而不选择数据系列时, Excel才会显示趋势线选项。(Trendline)
3]格式化趋势线
再次按“+”号,选择“趋势线(Trendline)”,向下滚动并选择“更多选项(More options)”
当“格式(Format)”窗格变得可见时,在下拉列表中选择趋势线选项。
默认情况下,Excel会插入一条线性趋势线。但是,您可以添加您选择的其他变体,例如,
在Forward(Forward)和Backward字段中设置一个值,以将您的数据投射到未来。格式化趋势线是一种测量数据的统计方法。
4]添加移动平均线
如果您想将趋势线格式化为移动平均线,您可以这样做。为了这,
单击图表中的任意位置。
切换到“格式(Format)”选项卡,在其“当前选择(Current Selection)”组下,选择下拉列表中的趋势线选项。
接下来,单击“格式选择(Format Selection)”选项。
然后,从“趋势(Trendline)线格式”窗格的“趋势线选项(Trendline Options)”下,选择“移动平均线(Average)” 。如有必要,请指定点。(请(Kindly)注意,移动平均趋势线中的点数等于该系列中的总点数减去您为该期间指定的点数)。
这样,您可以将趋势线添加到Excel图表并在其信息中添加更多深度。
How to add a Trendline in Microsoft Excel worksheet
One can easily determinе the trend that emerges from the exiѕting data by аdding a Trendline to it. Microsoft Excel featureѕ this tool. As such, it cаn show prediсt the general pattern and the overall direction of your data. Let us walk you through the steps to add a Trendline in Office Excel.
Add a Trendline in Excel worksheet
Trendline in Excel is a line that shows a general trend (upwards/downwards or increase/decline). Thus, it can help in a quick interpretation of the data. The trendline in Excel can be added to a variety of charts, including bar charts, line charts, scatter plots and more.
Let’s quickly get you through the process of-
- Creating a chart
- Adding a trendline
- Formatting a trendline
- Adding a moving average line.
Please note that the steps in this post apply to Office 2019/2016/2013 versions.
1] Creating a chart
Enter the data for which you want to create a chart.
Next, select the data and choose ‘Insert’ tab.
Scroll through the category of ‘Recommended Charts’ and click any chart to get a preview of the data (If you don’t see a chart you like, click All Charts to see all the available chart types).
2] Adding a trendline
After having created a chart, select it, and hit the ‘+’ icon visible adjacent to the chart.
Scroll down the list of options and select ‘Trendline’.
Click the side-arrow to view more options and choose the desired option.
Please note that Excel displays the Trendline option only when you select a chart that has more than one data series without selecting a data series.
3] Formatting a trendline
Again, press the ‘+’ sign, choose ‘Trendline’, scroll down and select ‘More options’
When the Format pane becomes visible, select the trendline option in the dropdown list.
By default, Excel inserts a linear trendline. However, you can add other variations of your choice like,
- Exponential
- Linear
- Logarithmic
- Polynomial
- Power
- Moving Average
Set a value in the Forward and Backward fields to project your data into the future. Formatting a trendline is a statistical way to measure data.
4] Add a moving average line
If you feel like formatting your trendline to a moving average line, you can do so. For this,
Click anywhere in the chart.
Switch to the ‘Format’ tab, and under its ‘Current Selection’ group, select the trendline option in the drop-down list.
Next, click ‘Format Selection’ option.
Then, from the Format ‘Trendline‘ pane, under ‘Trendline Options‘, select Moving Average. Specify the points if necessary. (Kindly note that the number of points in a moving average trendline equals the total number of points in the series less the number that you specify for the period).
This way, you can add a trendline to an Excel chart and add more depth in its information.