Chart type - change with combobox selection

[scouse13]

hi guys, I have a lot of charts which I started of being able to change via command buttons, have now changed to using option buttons, but was thinking there must be a way to have a combobox selection that can change the chart from say column to pie, when I put an active x dropdown on a sheet, there is no rowsource to add a list and the form dropdown only gives the option of assigning a macro,
whats the best way to achieve this
any help appreciated

scouse13

[scouse13]

No worries now guys sorted it, I said row source, that's on a userform, on a sheet it is the listfillrange in the properties section to pick up named ranges