| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart with 2 sets of data
Hi,
I need to create a scatter chart using two set of data. I have Samples A1-A10 and B1-B10 with mass and volume for each. I need mass on the x axis and volume on the y axis. The chart should have two separate "lines" for A samples and B samples. How do I accomplish this? Thank you so much! Dimple |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart with 2 sets of data
The easiest way is probably to select the X and Y data for series A (with
mass in the left hand column and volume in the right hand column) and create the chart, then similarly select the X and Y data for series B (again with mass in the left hand column and volume in the right hand column), then go to the chart and Edit/ Paste Special/ New Series -- David Biddulph "Dimple" wrote in message ... Hi, I need to create a scatter chart using two set of data. I have Samples A1-A10 and B1-B10 with mass and volume for each. I need mass on the x axis and volume on the y axis. The chart should have two separate "lines" for A samples and B samples. How do I accomplish this? Thank you so much! Dimple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create a chart with 4 sets of data? | Charts and Charting in Excel | |||
| How do I use 2 sets of data in a chart | Charts and Charting in Excel | |||
| How to chart 3 sets of data? | Charts and Charting in Excel | |||
| I want to overlay three data sets in the same chart | Charts and Charting in Excel | |||
| Two sets of data on one chart | Excel Discussion (Misc queries) | |||
Linear Mode
