Microsoft Office Tutorials and References

In Depth Information

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 and a pivot chart.