1. Home
  2. MS Office

Excel 2010: Add Trendline in Chart

Excel 2010 includes Trendline which is a great data visualization tool to show the trend of specified data range. There are three kinds of trendlines; Linear Trendline, Exponential Trendline, and Linear Forecast Trendline. This post covers how to apply trendlines over the chart.

For inserting trendlines in chart, select a chart and navigate to Chart Tools Layout tab, From Trendline options, select a required type.


It will instantly insert trendline of specified type.


Leave a comment

  • theDude()

    Great!! Thank you!

  • zathras_1

    Thanks – I even looked at the layout tools before searching and didn’t see it – duh!

  • rhonda b

    what if he TRENDLINE item is grayed out