Microsoft Office Tutorials and References
In Depth Information
The chart uses two dynamic names in its SERIES formula. You can define the name
Categories
with the fol-
lowing formula:
=OFFSET(Sheet1!$E$4,0,0,ROUNDUP(100/BinSize,0))
Figure 7-12:
The chart displays a histogram; the contents of cell E1 determine the number of categories.
You can define the name
Frequencies
with this formula:
=OFFSET(Sheet1!$F$4,0,0,ROUNDUP(100/BinSize,0))
The net effect is that the chart adjusts automatically when you change the
BinSize
cell.
See Chapter 17 for more about creating a chart that uses dynamic names in its SERIES
formula.
Summing Formulas
