Creating Multiple trendlines on one graph

Question

Level 1

0 points

Creating Multiple trendlines on one graph

I'm showing a density relationship and not all of the weights or ml's are the same. Is there a way I can graph this? Or is there a really good tutorial somewhere? I've been searching but maybe I'm not using the right words.
ex.

zinc, 3.1g/.5ml 2.6g/.41ml etc.... I know how to get a get a line for that but if I want to add
copper 4.6g/.60 ml, 2.9g/.39ml... etc to the same graph, how will I keep them separate? I'm unable to create multiple trend lines on the same graph.

thanks

imac, Mac OS X (10.5.8)

Posted on Sep 3, 2009 11:03 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Sep 3, 2009 11:17 AM in response to tednunes

At first read, I think that I would build several charts then superpose them.

Yvan KOENIG (VALLAURIS, France) jeudi 3 septembre 2009 20:17:13

Reply

Answer 2

Badunit

Level 7

30,714 points

Sep 3, 2009 12:28 PM in response to tednunes

You need to plot two series of data to have two trendlines. It would make sense to have two series anyway because you have two different materials.

Zinc X values (ml?) in column B
Zinc Y values (g?) in column C
Copper X values (ml?) in column D
Copper Y values (g?) in column E

Select all four columns, create a scatter chart. Create trendlines for each series.

If you already have the two columns for Zinc, just add the columns for copper and add them to the chart. Select the chart and you'll get a box around your data. Drag the little circle in the lower right to expand the box to cover your two new columns.

You can also make the same chart with only three columns (one X and two Y) but it's a little more difficult.

Reply

Answer 3

tednunes Author

Level 1

0 points

Sep 4, 2009 9:11 AM in response to tednunes

Sweet... I think this is going to work. I appreciate your time.

Reply