ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I chart two separate sets of x and corresponding y values . (https://www.excelbanter.com/charts-charting-excel/162231-how-do-i-chart-two-separate-sets-x-corresponding-y-values.html)

The Bewildered

How do I chart two separate sets of x and corresponding y values .
 
I would like to chart two sets of x and y values with each set of x values
corresponding to its own set of dependant y values. The two sets of x values
for the ordinate are entirely different. It seems like I can only chart two
sets of data on the same graph with the same values for x and two separate
sets of dependant values for y. Is there any way possible to get around this
problem?

David Biddulph[_2_]

How do I chart two separate sets of x and corresponding y values .
 
Select your first set of X&Y data, Insert/ Chart (Chart type XY, & choose an
appropriate sub-type)/ other options as appropriate.
Now select your second set of X&Y data, Copy, select your chart, Edit/ Paste
Special/ New Series/ X values in first column, other options as applicable.
--
David Biddulph

"The Bewildered" <The wrote in message
...
I would like to chart two sets of x and y values with each set of x values
corresponding to its own set of dependant y values. The two sets of x
values
for the ordinate are entirely different. It seems like I can only chart
two
sets of data on the same graph with the same values for x and two separate
sets of dependant values for y. Is there any way possible to get around
this
problem?





All times are GMT +1. The time now is 03:06 AM.

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