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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M_LeDuc - 13 Sep 2007 18:56 GMT

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!

Reply to this Message

David Biddulph - 13 Sep 2007 19:55 GMT

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

Signature

David Biddulph

>I Need to create a chart with lots of horizontal curves at different Y
>values.
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Del Cotter - 13 Sep 2007 22:26 GMT

>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message