Using a scatter chart automatically plots the ranges against their frequencies, but using a column graph creates a familiar histogram type chart. Open Microsoft Excel and list your data in column A.

An Excel pie chart displays categories of data as wedges in a circular graph. This format allows users to quickly see the contribution each category makes to the total figure and a correlation of ...