Dynamic charts from data in a row x column dataset - advice please

[Takeshi]

Hi,

I have data in a tabular format (RxC), created by a macro, not a pivot
table. I want to be able to create a dynamic chart linked to the data as ff:

1). I will have a drop down combo box with a list of all the available
columns
2). Upon selecting an item from the combobox, a line chart is produced
for the selected column.

Is there any way I can do this ?

MTIA

 

[Debra Dalgleish]

Jon Peltier has instructions for using checkboxes to display series in a
chart:

http://peltiertech.com/Excel/Charts/Dynamics.html#SheetControls