How do I add a trendline to a chart?

V

Valerian

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

Valerian

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

Valerian

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