How do I add a trendline to a chart?

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...
 
R

Rick Brandt

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.
 
R

Rick Brandt

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.
 
G

Guest

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...
 
G

Guest

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.
 

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
Trendline Question 0
How to deteremine the number of trendline in chart? 2
Can't add trendline in Excel 2007 2
Sr. Citizen Question On Adding A Trendline, Please ? 1
Trendline Percent 3
Trendline Question 1

Top