Excel treats the Category axis values for all other chart types as the list to calculate the trend and its formula, where n is the number of text elements on the axis.Īttention! Excel takes the first value as x = 1, not x = 0 as usual.
Excel generates a mathematically correct trend line using data values only for the XY scatter plot because the Y-axis and the X-axis are real numeric values for this type of chart.When creating a trend line, you should remember that Excel treats any data along the axes as numbers:.You cannot add a trendline for 3-D or stacked charts, pie, radar, and similar.
Excel makes adding a trend line to a chart quite simple.
0 kommentar(er)
