Microsoft Office Tutorials and References
In Depth Information
Controlling a Series with a Scroll Bar
This formula uses cell B2 as the anchor cell and returns a reference to the range
that is
Offset from cell B2 by 0 rows (second argument, rows )
Offset from cell B2 by 0 columns (third argument, cols )
Ten cells high (fourth argument, height )
One cell wide (fifth argument, width )
In other words, the OFFSET function returns a reference to range B2:B11, and
this is the range used by the chart series. When a new data point is added, the
OFFSET function returns a reference to range B2:B12.
Subsequent examples in this chapter use the same basic concept but vary in the
arguments supplied to the OFFSET function.
To keep things simple, the charts in this chapter make use of a single data
series. However, these techniques can be applied to charts with any number
of data series. You will, however, have to make the necessary adjustments for
each series.
Controlling a Series with a Scroll Bar
The example in this section demonstrates another type of interactivity. Figure 7-4
shows a chart that uses a Scroll Bar control to specify the number of months (from
1 to 12) to display.
Figure 7-4: The scroll bar at the top of the chart controls how many months
are displayed.
Search JabSto ::




Custom Search