View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default 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.