Histogram Charts are one of the many new Charts available only in Excel 2016.

They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common.

In this example I show you how easy it is to insert a Histogram Chart using Excel 2016.

To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Highlight your column with numerical data and go to Insert > Recommended Charts

Histogram Chart 01

Histogram Chart 02

 

STEP 2: Select All Charts > Histogram > OK

Histogram Chart 03

 

STEP 3: Now you have your Histogram Chart.

Histogram Chart 04

 

STEP 4: You can further change the way how your Histogram Chart represents your data, by double-clicking on the horizontal axis containing our values.

Histogram Chart 05

 

STEP 5: In the Format Axis window, pick the third option Axis Options. Let us go through the options you can use:

 

Automatic – Excel does the heavy lifting for you, and determines what the size of each bin would be.

Bin width – You tell Excel how many units each bin should be. In our example below, we are telling Excel that we want each bin to cover 9,984 units each.

Number of bins – Excel will automatically determine the size of each bin, however you can modify the number of bins.

Overflow bin – This will set a threshold for your bins, any value above this threshold will be placed in this bin.

Underflow bin – This will set a threshold for your bins, any value below this threshold will be placed in this bin.

 

Histogram Chart 06

 

STEP 6: Try out the following settings to modify the Histogram Chart:

Number of Bins – 20

Overflow Bin – 90,000

Underflow Bin – 20,000

Histogram Chart 07

 

Now you have your cool Histogram chart and you can quickly point out to your management which range of values are the most common ones…

Histogram Chart 08

Histogram Chart

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar! The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977. They show you the distribution of a data set, showing the median, quartiles, range and outliers. The X in the box represents the Mean. ...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...