Microsoft Office Tutorials and References
In Depth Information
Advanced Counting Formulas
Figure 7-9: The Analysis ToolPak’s Histogram dialog box.
Specify the ranges for your data (Input Range), bins (Bin Range), and results (Output Range), and
then select any options. Figure 7-10 shows a frequency distribution (and chart) created with the
Figure 7-10: A frequency distribution and chart generated by the Analysis ToolPak’s Histogram option.
Note that the frequency distribution consists of values, not formulas. Therefore, if you
make any changes to your input data, you need to rerun the Histogram procedure to
update the results.
Using a pivot table to create a frequency distribution
If your data is in the form of a table, you may prefer to use a pivot table to create a histogram.
Figure 7-11 shows the student grade data summarized in a pivot table. The data bars were added
using conditional formatting.