Well - I have found a way that may not be elegant but it works!

What I had to do was import the data table and then create a lookup
table showing the column headings with a second column showing the
column number (col A = 1, col B =2 etc)

Using data validation I created the dropdowns to select the X and Y
axis variables. I then used the lookup table to convert the variable
name in the drop down into a column number.

Finally I set up named ranges xaxis and yaxis using the column numbers
to offset from column A.

If anyone can show me a simpler or more effective way I would love to
know it.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=400730