How do I add multiple trendlines to a chart?

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

Guest

I can only at present add one trendline to a chart - is it possible to add
mutiple trendlines to the same chart?
 
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
 
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/
_______
 

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 in a stacked graph chart 1
Trendline Percent 3
different color on scatter plot separated by a trendline 1
Trendline in Stacked Column Chart 2
Trendline partial data 2
Trendline Issues 4
Connect bars in a column chart 4
Ploynomial Trendline Equation Changes After Copy Paste 11

Back
Top