This is useful as it shows the trend better by smoothening any fluctuations. 3 minute Combo Chart with Excel for Mac 2016 For example, if you do a 3-part moving averageit will show you the trend based on the past three periods. This is often used to show the trend by considering an average of the specified number of periods. It will show you all the trendlines that you can use in Excel.Īpart from linear trendline, another useful option is a moving average trendline.
Power Moving Average Here is a good article that explains what these trend lines are and when to use these.
