View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] trorrer@comcast.net is offline
external usenet poster
 
Posts: 3
Default Multiple Ranges against one Domain

I used to be able to do this but now I can't seem to find the
functionality

I would like to plot multiple ranges (y-values) against a single range
(x-values)
example:

Y[1]: 1, .89,.56,.45,.25,.02
Y[2]: 1,.87,.45,.35,.20,.05
..
..
..
Y[n]:1,.82,.83,.32,.04,.04
Plot each Yset against one range (x-set)

X[1]: 3.45,3.15,2.56,1.22,.789,.45

I can brute force it: source data- add series - select x-data -
select y-data[1]........
but I have 100's of ranges all to plot against the same domain, all
against X[1]
Thanks in advance