On Sun, 13 Jan 2008, in microsoft.public.excel.charting,
hmm said:

I have tables with many columns. I want to create a chart that will allow me
to specify which columns to use for x- and y-axes, preferably with two
pull-down menus. Basically, I want to avoid the present situation where I
create a new chart every time I want to observe the correlation between two
variables.

The method I use is to create an x and y column which consists of
INDEX() functions, which refer to the column of interest via a cell at
the top of the column

INDEX(range,row,column)

You can refine this system as much as you want, depending on how much
effort you want to put into it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.