You can use the Frequency function within Excel in Microsoft Office ... From that calculation you can then create a graph which shows the frequency distribution of the data you've collected.

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

and sharing data in an Excel chart, it is helpful to be able to represent it in a manner that is quickly and easily understood. Creating a bar or column graph is a great way to do so, since you ...