blackhaa.blogg.se - Add horizontal line in excel pivot chart

The Format Trendline pane opens and presents all trendline types and further options. To see the full complement of options, click “More Options.” It uses a specified number of data points (two is the default), averages them, and then uses this value as a point in the trendline.

Moving Average: To smooth out the fluctuations in your data and show a trend more clearly, use this type of trendline.

Logarithmic: This type is best used when the data increases or decreases quickly, and then levels out.

The line is more curved than a linear trendline.

Exponential: This trendline visualizes an increase or decrease in values at an increasingly higher rate.

Linear: A straight line used to show a steady rate of increase or decrease in values.

There are different trendlines available, so it’s a good idea to choose the one that works best with the pattern of your data.Ĭlick the arrow next to the “Trendline” option to use other trendlines, including Exponential or Moving Average.