Can 3 graphs be put on one diagram

[phantomsteve]

I'm not sure if this is possible, but I'm trying to plot my 3 kids' weights over time on the same chart.

Data Format:

	A	B	C	D	E	F	G	H	I
1	Child 1 - Day	Child 1 - Weight		Child 2 - Day	Child 2 - Weight		Child 3 - Day	Child 3 - Weight
2	0	2.866		0	3.464		0	2.294
3	10	2.940		9	3.630		20	2.360
4	16	3.060		15	3.920		27	2.420
5	31	3.580		36	4.6		38	2.600

I have also defined names:
$A$2:$A$5 Ch1_Days
$B$2:$B$5 Ch1_Weights

$D$2:$D$5 Ch2_Days
$E$2:$E$5 Ch2_Weights

$G$2:$G$5 Ch3_Days
$H$2:$H$5 Ch3_Weights


I can create a chart for each child individually, but is there any way to put all three onto one chart? I know it's more awkward as they aren't all weighed on the same "day" - if they were all weighed on the 7th, 14th, 21st day, etc, then it'd be easy!

Any ideas?

Regards,
Steve

[MrShorty]

It looks like it should be easy with a scatter plot, because you can define the "x values" range independently. Select one data set and bring up the insert chart wizard (or whatever it is in 2010). At the step where you confirm/select the source data, make three different data series, one for each child, with the appropriate y and x ranges. finish the chart and format as desired.

[Pete_UK]

See attached file. I used an XY graph with lines joining the points and added 3 series to it. Very little other formatting, though.

Hope this helps.

Pete

[phantomsteve]

That is exactly what I need... thank you very much!

Steve