ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chart with 2 sets of data (https://www.excelbanter.com/excel-discussion-misc-queries/204560-chart-2-sets-data.html)

Dimple

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

David Biddulph[_2_]

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





All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com