Microsoft Office Tutorials and References
In Depth Information
Creating the chart
Figure 7-15: The series displayed in the chart are controlled
by check boxes.
Creating the chart
The chart in this example is a standard line chart that uses the data in A1:D13.
Adding the Check Box controls
To add the check boxes to the worksheet:
1. Select View
Toolbars
Forms to display the Forms toolbar.
2. On the Forms toolbar, click the Check Box control and then drag in the
worksheet to create the control.
3. Right-click the Check Box and choose Format Control from the shortcut
menu. This displays the Format Control dialog box.
4. In the Format Control dialog box, click the Control tab.
5. In the Cell link field, enter $G$4 . This will link the Check Box control
with the cell G4, which will display either TRUE or FALSE, depending on
the state of the Check Box control.
Search JabSto ::




Custom Search