Excel – Why can’t I add a trendline to a chart in Excel 2007


I created a really simple chart based on 2 columns (date and numeric value).
I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out.

What am I missing?

Best Answer

  1. Just select the chart you want to add/activate a trendline then
  2. click "INSERT" tab just after "home" office tab then
  3. click the drop down arrow of "Area" chart type, then
  4. select "Area" instead of "Stacked area"
Related Question