Much more creative than my answer, Andy!
But I do have a bad case of 'flu
best wishes
--
Bernard

"Andy Pope" wrote in message
...
Hi,

No need for a macro.

You could use formula, such as INDEX, to display values of chosen column.
Then create a chart on this fixed set of data.

You could use a Spinner control to determine which of the 100 columns you
what displayed.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Cath" wrote in message
...
Scenario : I have a large data table, possibly 100 cols wide and 100 rows
deep. I have created a graph built from one column worth of data. Can I
create a macro which when used will move the source of the data to the
nextcolumn, with this being carried out repeatedly.

I only want to display one col at a time in the graph. I would like to
have
two buttons - one for moving to the next column and one to move back to
the
previous column. Is this possible ?
--
Thanks
Cath