Microsoft Excel 2010 lets you add a trend line to a chart in a spreadsheet to represent your datas current and future trends.Excel draws the two ends of the trend line based on your existing data values.You can access the trend line options in Excel to extend the line beyond the initial points to forecast future values of your data.Type a value in the Forward field to extend the trend line forward, and type a value in the Backward field to extend it backward.
Your browser may include features that can help translate the text. This solution might also apply to other similar products or applications. Right-click on the Sheet 1 tab at the bottom of the window and select Add New Sheet to End. Click on your data in the Data Portal and drag it into the Display Window. You should see a preview of the trendline set against your data, but the trendline may not be intersecting the origin. Check as many polynomial function boxes as you want, up to ten may be selected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |