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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2-y axis line chart 4
charting variable line data 1
VBA Code to Export Data from Chart 4
charts look different if you put in data into the x axis 3
Scatter Chart 1
Chart Macro Help Needed 1
Excel chart does not start at zero. 1
Charting: Multiple workbooks one chart 3

Top