How do I add multiple trendlines to a chart?

[Guest]

I can only at present add one trendline to a chart - is it possible to add
mutiple trendlines to the same chart?

 

[Bernard Liengme]

You can have one and only one trendline for each data series. There is
however, nothing to stop you 'cheating' and adding the same data series to
the chart twice. Now the problem is how to select the second series to add
trendline. Use the arrow keys to more thru chart items, watch the name box
to see what has been selected

best wishes

 

[Jon Peltier]

Actually, you can add more than one trendline per series. In the Add Trendline
dialog, on the Type tab, keep selecting the same series in the Based on Series dropdown.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______