Have a look here
http://peltiertech.com/Excel/Charts/...#SheetControls

You can link form control comboboxes to a worksheet such that the selected item is known. With that information you can then use named ranges to alter chart data