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

Histogram option.

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.