View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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