LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF with multiple disjoint ranges, same criteria Bob Phillips New Users to Excel 1 March 3rd 06 11:02 PM
COUNTIF with multiple disjoint ranges, same criteria CLR New Users to Excel 0 March 3rd 06 08:00 PM
how to merge ranges from multiple worksheets crowleydl Excel Worksheet Functions 0 August 5th 05 07:24 PM
compare unique identifiers in multiple ranges bawilli_91125 Charts and Charting in Excel 1 November 30th 04 06:34 PM
Countif & ranges consisting of multiple areas Jurry Excel Worksheet Functions 1 November 15th 04 09:03 AM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"