Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
COUNTIF with multiple disjoint ranges, same criteria | New Users to Excel | |||
how to merge ranges from multiple worksheets | Excel Worksheet Functions | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |