You are on the Home/Excel/Tutorials/Dynamic Charts/Drop Down Box page
Web This Site

To create the drop-down box for use in a worksheet (as in example 6 in the dynamic_charts page), follow the directions below


The Forms toolbar contains the Combo box control.

snapshot025.jpg (34412 bytes)

Select the Combo Box, draw it on the worksheet so that it covers cell F1


Right click on the box, and select Format Control...  From the Control tab, specify the Input Range as XRange, and the Cell Link as $F$1 (remember, it is easier and less error prone to click the cell with the mouse rather than type in the cell address).

snapshot029.jpg (15760 bytes)

Click anywhere in the worksheet so that the drop-down box no longer has the handles (squares at the corners and the centers of the edges) around it.  Now it is ready for use.  Select any month as the starting month and watch the chart change.