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 ...

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

Select the two sets of data you want to use to create the graph. Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.