Throughout this page are “PROTIP” flags that highlight advice from experience not available elsewhere. 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. Create a Histogram in Microsoft Excel 2013Ī histogram is a bar graph (visualization) that shows the occurrence of values in each of several bin ranges.Category Frequency Distribution in Microsoft Excel 2013.
