Microsoft Office Tutorials and References

In Depth Information

**Animating Charts**

h
ProdB
: A named formula:

=OFFSET(Sheet1!$C$1,StartDay,0,NumDays,1)

Figure 18-22:
The values in column F determine which data to display in the chart.

Each of the SERIES formulas in the chart uses names for the category values and the data. The

SERIES formula for the Product A series is as follows (I deleted the sheet name and workbook

name for clarity):

=SERIES($B$1,Date,ProdA,1)

The SERIES formula for the Product B series is:

=SERIES($C$1,Date,ProdB,2)

Using these names enables the user to specify a value for
StartDay
and
NumDays
, and the

chart will display a subset of the data.

The companion CD-ROM contains a workbook that includes this animated chart, plus

several other animation examples. The filename is
scrolling chart.xlsm
.