Microsoft Office Tutorials and References
In Depth Information
Using the List Box Control
8. (Optional) You can check the 3-D property if you want the control to have a 3-D appearance.
9. Click OK to apply your changes.
Figure 12-22: Formatting the list box control.
List box example: Controlling multiple charts
with one selector
One of the more useful ways to use a list box is to control multiple charts with one selector. Figure
12-23 illustrates an example of this. As a region selection is made in the list box, all three charts are
fed the data for that region, adjusting the charts to correspond with the selection made. Happily, all
this is done without VBA code, just a handful of formulas and a list box.
Figure 12-23: This list box feeds the region selection to multiple charts, changing each chart to correspond with
the selection made.
To create this example, you start with three raw datasets (as shown in Figure 12-24) that contain
three categories of data: Revenues, Net Income %, and Gross Margin. Each dataset contains a
separate line for each region (including one for All Regions).