Excel Hack 82: Create dynamic charts in Microsoft Excel
You may have encountered an Excel worksheet with the below feature – a chart that changes values based on a selection from a drop-down button or combo box. This functionality is powered by a combination of Form Controls (Combo Box in particular) and an Excel chart which takes its source from a dynamic range that