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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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".
 
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 ...
Click to expand...

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