Chart with 2 sets of data

D

Dimple

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
 
D

David Biddulph

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
 
Top