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 .
 
Search JabSto ::




Custom Search