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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|