A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

charting data with multiple series



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2003, 03:38 PM
Mary
external usenet poster
 
Posts: n/a
Default 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
  #2  
Old September 26th, 2003, 06:24 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default charting data with multiple series

[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 ,
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.