Create a histogram in Excel

Excel 2013

  • Make sure you load the Analysis ToolPak to add the Data Analysis command to the Data tab.

  • On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column.

  • Click Data > Data Analysis > Histogram > OK.

  • Under Input, select the input range (your data), then select the bin range.

  • Under Output options, choose an output location.

  • To show the data in descending order of frequency, click Pareto (sorted histogram).

  • To show cumulative percentages and add a cumulative percentage line, click Cumulative Percentage.

  • To show an embedded histogram chart, click Chart Output.

  • For more information, see Create a histogram.

Excel 2016

  • Select your data.

  • On the Insert tab, click Insert Statistic Chart > Histogram.

    Screenshot showing a mouse cursor selecting a histogram on the insert tab of the Office ribbon
  • For more information, see Create a histogram