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. In Excel, trendlines can be added for 2-dimensional charts only: a 2-D area, bar, line, column, stock, scatter, or bubble chart.
Excel makes adding a trend line to a chart quite simple.
