multi graph line on one chart

[Harry]

Hi to all:

I have 3 set of data and graph them separately with x and
y line chart. How I need to put these 3 graphs into one
chart. Can this be done? I tried to use the series but
the x category axis keep changing to the latest
selection. Any ideas on how to put multi graphs on one
chart?

Thanks in advance.

 

[Debra Dalgleish]

You can try the following:

1. Create an XY Scatter chart from the first set of data.
2. Select the next set, and copy it.
3. Select the chart, and choose Edit>Paste Special
4. Select Add cells as: New Series
5. Choose the appropriate setting for Values (Y).
6. Add a check mark to 'Category (X) values in first column'
7. Click OK

Repeat steps 2-7 for additional sets of data.

 

[Harry]

Thank you. that's just what I am looking for.

-----Original Message-----
You can try the following:

1. Create an XY Scatter chart from the first set of data.
2. Select the next set, and copy it.
3. Select the chart, and choose Edit>Paste Special
4. Select Add cells as: New Series
5. Choose the appropriate setting for Values (Y).
6. Add a check mark to 'Category (X) values in first column'
7. Click OK

Repeat steps 2-7 for additional sets of data.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.