Adding A Trend Line To Your Excel Chart


Did you know that Excel can add a trend line to the data points in your charts?.

Say we have a weight loss tracker, and we have been tracking weight loss for 4 weeks, The BLUE line is the weight lost, the GREEN line is the weight loss that is required to meet the goal of total weight loss at the end of 6 weeks.

We can see the BLUE line is going down, but just how close is the goal weight and will it be met after 6 weeks at the current weight loss rate?. Excel can add a trend line as a forecast to where the weight loss will be at the end of the 6 eeeks based on it’s current rate.

Right click on the BLUE line which is the actual weight loss data points.

Hit add trend line. There are six types available, I choose linear. Instantly Excel will add a trend line nbased on the prior data values in my actual weight loss data.

The GREEN line obviously indicates that the weight loss goal will indeed be missed at the going rate.

If you want to format the trend line then just right click the trend line and format as you wish.

 

Isn’t that cool? The trend line, not missing the weight loss goal!!

 

 

 

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts