Trendlines aren’t available with all types of charts. However, if you are using an area, bar, line, column, stock, scatter, or bubble chart that’s 2-dimentional, a trendline can be applied. There are six different types available. Use the table below to determine the right type of trendline for your chart and data.
Chart Types in Excel
Exponential trendlines work only for data sets with positive values. They’re best for data that increases or decreases at a quick rate.
Linear trendlines are best for simple sets of data where the data points are in a line that increase or decrease at a steady rate.
If your data increases or decreases quickly and then evens out, a logarithmic trendline is the best to use. They are curved trendlines and can be used for charts with both positive and negative values.
Polynomial trendlines are curved lines for data with positive values. Use these if your data set fluctuates and you need to assess the ups and downs of a large set of data.
Power trendlines are also curved lines for data with positive values. If your data increases at a specific rate, power trendlines are the best to use.
If your data has large fluctuations, a moving average trendline is best. They help neutralize variations to give you a better idea of the underlying trend.