Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Excel 2013

  1. Make sure you load the Analysis ToolPakto add the Data Analysis command to the Data tab.

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

  3. Click Data > Data Analysis > Histogram > OK.

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

  5. Under Output options, choose an output location.

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

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

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

  9. For more information, see Create a histogram.

Excel 2016

  1. Select your data.

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

  3. For more information, see Create a histogram

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!