I often want to look at XY plots of various combinations of data. What I
would like to be able to do is simplify (and speed up) the process by
being able to select the x and y series using dropdown lists.

ie: I import the data (varying rows and columns) into a sheet and then
use Insert Name Create to turn each column into a named range.

On a new worksheet I use Insert Name Paste to give a list of the range
names from which I can then select my X and Y ranges using drop downs.


The question is - how can I set up an XY chart so it takes its range
names from the dropdowns?


--
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