I was playing w/ a time series data set in Excel 2010 and learned how to add a Trend-line and in this blog post, I’ll share how I added it:

First up, How is Trend-line useful? Here are few answers:
– It helps us see how data is changing over time, in other words, it helps us find “trends”
– It helps us forecast future.

With that, here is the chart without Trend-line:

Now let’s add the trend-line and you’ll be able to compare on your own how Trend-line makes it easier to spot “trends”. Here are the steps:

1. select the line > right-click > add trend line

2. configure the trend-line options

3. I also changed the line style

4. And Here’s the chart w/ trend-line

Conclusion:

In this post, we saw how to add trend-line in the time series chart in excel 2010

Related articles

• Need to combine two chart types? Create a combo chart and add a second axis (blogs.office.com)