|
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. |
 |
|
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). |
 |
|
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. |
 |
|
