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

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!

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

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".
--
David Biddulph

"M_LeDuc" wrote in message
...
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!

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

On Thu, 13 Sep 2007, in microsoft.public.excel.charting,
M_LeDuc said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.