How to Use Excel to Find the Mean, Median & Mode Ranges. ... Press "Enter" and the cell will display mode of the data set. ... How to Make a Curved Chart for Standard Deviation in Excel.

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.