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.