Trendlines make it easier to see trends and patterns in your data. Excel Video 454 shows how to add a trendline to your chart. Trendlines are added a series at a time. Watch how to add a trendline, the types of trendlines to add, how to rename a trendline, and how to add equations describing the trendline to your chart. If you’re grateful to have survived algebra and y=mx+b, leave the equations out. If your reader is familiar with y=mx+b and correlation, the equations are a helpful addition.
Trendlines can also be used to forecast data. Watch Excel Video 455 to see how.