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

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.