Thank you Joel.

Gerry
"joel" wrote in message
...

What you need to do is create a new table to use for plotting that has
only one series in it, but has a formula that takes the the correct
column (1 of 4) from your original table. You can use the function
Offset to get the data from one of 4 columns



So if you wanted to get the data the is either 0,1,2,3 from A1 you
would use this

=OFFSET(A1,0,X,1,1)

You can then put a formula into X that determines which column has the
results you are looking for


You can use Chip Pearson's web page to help you get the exact formula
you need. He has a large number of formulas that you can use.

www/cpearson.com


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=162970

Microsoft Office Help