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

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

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

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

Takeshi wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html