So, don't expect a proper intersection with Y-axis.įor example, for a line chart, the vertical (Value) axis crosses the horizontal (Category) axis at a non-zero position - see the example above.
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. 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.
