If you change the chart type to a chart types that does not support trendlines then the trendline will not be displayed (deleted ?)įor line data when you do not need a chart you can use the AutoFill or one of the stats functions GROWTH or TREND to create data for best-fit linear or exponential lines. You can also use Moving Averages to smooth out the fluctuations in a data series.Ī trendline can be added to a data series in the following chart types: xy scatter, area, bar, column, line, stock, bubbleĪ trendline cannot be added to data series in a stacked, 3D, radar, pie, surface or doughnut chart. Trendlines are often used for regressions analysis (or curve fitting). Trend lines can be helpful when you are analysing data because they can forecast future values based upon your current data. A trendline is an additional line that indicates the slope (or trend) in a particular data series and is also known as a line of best fit.
0 kommentar(er)
