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

simple chart 0
Trendline Not Appearing In Chart Problem ? 0
How to create a bubble chart with more than 2 variables. 0
Scatter charts for name with two values 0
Aligning line chart with column chart (4 categories) 0
PowerPivot How to chart with contiguous time axis? 0
Charting question - different units on same chart? 0
2-y axis line chart 4

Top