View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Cath Cath is offline
external usenet poster
 
Posts: 10
Default Creating a Macro which allows me to change the data series of a ch

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