Selectively Displaying a Data Series on a Chart

[Geronimo]

I have a spreadsheet which has 5 columns of data in columns B thru F in rows 3 thru 33. I wish to construct a chart with a combo box from which I can select any of the 5 columns of data, or all 5 columns, as a Data Series to display on the chart. Is it best to use a formula or VBA? Please advise!! Thank you for your kind attention & help! I appreciate it.
This message was edited by Geronimo on 2002-04-09 15:33

 

[Geronimo]

I'm going to try a different way, because the Index function is not working for me. I'm going to try a little simple VBA code for each data series I want to display on the chart