How do I add a trendline to a chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to add a basic trendline to a chart. I know I have seen it before but
I can't find it now that I need it. Go figure...
 
Valerian said:
I need to add a basic trendline to a chart. I know I have seen it
before but I can't find it now that I need it. Go figure...
Click to expand...

Double click the chart to bring up the chart designer interface. Then
single click on the series in the chart that you want to add a trendline
for. Once selected then right-click and choose "Add trendline" from the
menu.
 
Valerian said:
Rick,
Thanks but that option is greyed out. Any idea why?
Click to expand...

What is the chart type? Some types don't support trendlines. Column graphs
and line graphs definitely should and area graphs definitely do not. I'd
have to look at any others.
 
It is a line gragh. I am stumped???

Rick Brandt said:
What is the chart type? Some types don't support trendlines. Column graphs
and line graphs definitely should and area graphs definitely do not. I'd
have to look at any others.
Click to expand...
 
yes, I think it must have something to do with the way I created the chart.
Maybe I should start over? Thank you for all your time today.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendline Showing Problem ? 2
Pivot Chart Trendline? 0
Excel trendline formula: capital E 4
Trendline Question 0
Sr. Citizen Question On Adding A Trendline, Please ? 1
How to deteremine the number of trendline in chart? 2
Can't add trendline in Excel 2007 2
Trendline Question 1

Back
Top