Later on this page are steps to create a Histogram manually in macOS and Windows Excel 2016 and prior versions. Histograms provide a visualization of numerical data.įrequency distributions visualize categorical (text) data.