方法 1
方法 1 的 2:Windows
WH.shared.addScrollLoadItem(‘eb5e02044b2d268142eda91d46a40ba6’)
WH.performance.clearMarks(‘image1_rendered’); WH.performance.mark(‘image1_rendered’);{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8c/Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8c/Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”
1
打开Excel工作簿。双击数据所在的Excel工作簿文档。
如果在电子表格中没有想要分析的数据，可以打开Excel，然后点击”空白工作簿”打开新的工作簿。然后可以输入数据并从中 创建一个图表。WH.performance.mark(‘step1_rendered’);
WH.shared.addScrollLoadItem(’72fff6eba8f6c8e1ea2b5baef5963c3d’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e5/Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e5/Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”
2
选择图形。点击你想要设定趋势线的图表。
如果你还没有用数据创建图表，先创建一个。
WH.shared.addScrollLoadItem(‘259c37bad94b8c52f60f637e58243d1e’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ed/Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ed/Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”
3
点击＋。这是图右上角的一个绿色按钮。然后会出现一个下拉菜单。
WH.shared.addScrollLoadItem(‘40089d2d4775db32d659f5e344aaa863’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f6/Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f6/Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”
4
点击“趋势线”框右边的箭头。你可能需要把鼠标悬停在“趋势线”框的最右侧，好让这个箭头出现。点击它会弹出第二个菜单。
WH.shared.addScrollLoadItem(‘655cc6f662cc78e1fd19abdd815f2611’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/09/Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/09/Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”
5
选择一个趋势线选项。根据你的喜好，点击以下选项之一。
线性
指数
线性预测
双周期移动平均
你也可以在选择要分析的数据后，点击“更多选项”打开一个高级选项面板。
WH.shared.addScrollLoadItem(‘aadbf3b3fa635045316b6ecaf2751849’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4c/Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4c/Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”
6
选择要分析的数据。在弹出窗口中点击一个数据系列名称（例如“’系列1’”）。如果已经指定了数据，则单击数据的名称。
WH.shared.addScrollLoadItem(’15adf12b011a80ec4f5c4596fde7f243′)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/22/Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/22/Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”
7
点击OK。它在弹出窗口的底部。这样就可为图形添加趋势线。
如果你之前点击了“更多选项”，就可以选择给趋势线命名，或者在窗口右边改变趋势线的参数。
WH.shared.addScrollLoadItem(‘87960c191254b974e121b441650bbb5b’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”
8
保存工作。按{{keypress|Ctrl|S}保存更改。如果以前从未保存过这份文档，就会弹出提示让你选择一个保存位置和文件名。
WH.ads.addBodyAd(‘method_ad_1’)
WH.ads.addBodyAd(‘mobilemethod_ad_1’)广告
方法 2
方法 2 的 2:Mac
WH.shared.addScrollLoadItem(‘0a462c4a353387ea459885d94a7a848d’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”
1
打开Excel工作簿。双击存储数据的Excel工作簿文档。
如果在电子表格中没有想要分析的数据，可以打开Excel，然后点击”空白工作簿”打开新的工作簿。然后可以输入数据并从中 创建一个图表。
WH.shared.addScrollLoadItem(’40ee7364169fb4f6de742a06f9400b8f’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”
2
选择图形。点击你想要设定趋势线的图表。
如果你还没有用数据创建图表，先创建一个。
WH.shared.addScrollLoadItem(‘0111fd2db076638027f00a95ed75d725’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/be/Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/be/Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”
3
点击 图表设计 标签。在Excel窗口顶部。
X
研究来源
WH.shared.addScrollLoadItem(‘0f3fb03e2ce55c714090ec214ecc39d1’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2b/Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2b/Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”
4
点击添加图表元素。这个选项位于“图表设计”工具栏的最左边。单击它会出现下拉菜单。
WH.shared.addScrollLoadItem(‘bfe0fcf5c2f73d3bb0a6fc66dea930c6’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/05/Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/05/Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”
5
选择Trendline。在下拉菜单的底部。然后会出现弹出菜单。
WH.shared.addScrollLoadItem(‘d83e3eb987a78b178ac43d3f07eb38f4’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/63/Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/63/Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:”
6
选择一个趋势线选项。根据你的喜好，在弹出菜单中点击以下选项：[2]
X
研究来源
线性
指数
线性预测
移动平均
你也可以点击“更多趋势线选项”来打开带有高级选项的窗口（例如，趋势线名称）。
WH.shared.addScrollLoadItem(‘6444587649994eaf95d2f1570d0ef270’)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e2/Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e2/Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”
7
保存更改。按 ⌘ Command + Save，或点击“文件”-“保存”来保存更改。如果以前从未保存过这份文档，就会弹出提示让你选择一个保存位置和文件名。
WH.ads.addBodyAd(‘mobilemethod_ad_2’)广告
发表回复