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




Custom Search