Trendline of multiple series

G

geooil

Is there anyway I can create a trendline that incorporates thre
different sets of data on the same graph? :
 
A

Andy Pope

Hi,

You would need to add an extra data series that incorporated all 3 sets
of data. You could then add a trendline to this single data series.

The additional data series can be formatted, no pattern or border, so it
does not appear on the chart.

Cheers
Andy
 
J

Jerry W. Lewis

Or calculate the trendline in a worksheet and plot the trendline as a
separate series.

Jerry
 

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

Help with area under trendline 0
Trendline in Stacked Column Chart 2
How to add a trendline in Excel 2007 4
Trendline partial data 2
remove "linear" from trendline legend entry 2
Sr. Citizen Question On Adding A Trendline, Please ? 1
Trendline Not Appearing In Chart Problem ? 0
Creating one trendline for multiple series 1

Top