Microsoft Office Tutorials and References
In Depth Information
Using the Button Control
If you’re having a hard time figuring out how this could be useful, take a stab at this next exercise,
which illustrates how you can use a check box to toggle a chart series on and off.
Check box example: Toggling a chart series on and off
Figure 12-8 shows the same chart twice. Notice that the top chart contains only one series, with a check
box offering to Show 2011 Trend data. The bottom chart shows the same chart with the check box
selected. The on/off nature of the check box control is ideal for interactivity that calls for a visible/not
Figure 12-8: A check box can help create the disappearing data series effect.
To download the Chapter 12 Samples.xlsx file, go to the book’s companion
On the Web
You start with the raw data (in Chapter 12 Sample File.xlsx) that contains both 2011 and 2012 data
(see Figure 12-9). In the first column is a cell where the check box control will output its value (cell
A12, in this example). This cell will contain either True or False.
Figure 12-9: Start with raw data and a cell where a check box control can output its value.