How to create a scatter chart with 2 "X" values with common "Y"s

[Guest]

I Need to create a chart with lots of horizontal curves at different Y values.

there are 128 to be precise and I would prefer not to create each as an
individual series unless ... is there a way to copy a series mapping it tonew
cells?

(There are also a few diagonal curves so a bar chart wont work.)

Thanks!

 

[David Biddulph]

Just copy the cells from your spreadsheet that contain your data series,
then select the chart, Edit/ Paste Special, and choose the relevant options,
including "new series".

 

[Del Cotter]

I Need to create a chart with lots of horizontal curves at different Y values.
there are 128 to be precise and I would prefer not to create each as an
individual series unless ...

If you use a XY (Scatter) Chart series, there's no reason why your 128
lines can't be all one series. It would be 128*2 + 127 rows of cells,
like so:

X1 Y1
X2 Y1
[blank row]
X1 Y2
X2 Y2
[blank row]
X1 Y3
X2 Y3

.... and so on. X1 and X2 would be the left and right hand sides of the
graph, and Y1, Y2, Y3 etc. will be the heights of each line. Diagonals
are possible as well, as long as they're straight lines.