charting data with multiple series

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

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
 
Back
Top