How to Chart the Frequency of a Data Set on Excel. Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to ...

A frequency table has at least two columns. The last column shows the total or frequency for each item. A middle column showing tallies ... can sometimes be useful.