charting data with multiple series

I have a data set in this format:

Temp Pressure
Mass=115 2.2 897
4.1 752
6.3 631
8.5 555

Mass=125 1.3 999
4.6 888
8.9 777
9.6 600

Mass=130 3.6 987
4.5 876
6.9 654
8.0 555

and so on...

Using an XY Scatter Graph, I want to plot Temp vs.
Pressure for each data series. I want the labels in the
left column to show up in the legend. Any suggestions on
how to select the data?
Thanks,
Mary

[This followup was posted to microsoft.public.excel.charting with an
email copy to Mary.
Please use the newsgroup for further discussion.]

One quick and easy way to do this is to reorganize your data (or a copy
of the data) into a tabular format as in:

Type Temp Pressure
Mass=115 2.2 897
Mass=115 4.1 752
Mass=115 6.3 631
Mass=115 8.5 555
Mass=125 1.3 999
Mass=125 4.6 888
Mass=125 8.9 777
Mass=125 9.6 600
Mass=130 3.6 987
Mass=130 4.5 876
Mass=130 6.9 654
Mass=130 8 555

Now, create a PivotTable and PivotChart from this data (Data |
PivotTable and PivotCharts... though the name has changed with
different versions of XL). Put the Type as a column field, the Temp as
a row field and the Pressure as the data field. Select the Pivot Chart
and change the type to Line (Chart | Chart Type...).

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <e24f01c382a9$8d44b500$a601280a@phx.gbl>,
mahwal@umd.umich.edu says...
> I have a data set in this format:
>
> Temp Pressure
> Mass=115 2.2 897
> 4.1 752
> 6.3 631
> 8.5 555
>
> Mass=125 1.3 999
> 4.6 888
> 8.9 777
> 9.6 600
>
> Mass=130 3.6 987
> 4.5 876
> 6.9 654
> 8.0 555
>
> and so on...
>
> Using an XY Scatter Graph, I want to plot Temp vs.
> Pressure for each data series. I want the labels in the
> left column to show up in the legend. Any suggestions on
> how to select the data?
> Thanks,
> Mary
>