Advanced Excel Charts - Histogram

Advanced Excel Charts – Histogram

A Histogram is a graphical illustration of the distribution of numerical knowledge. It’s broadly utilized in Statistical Evaluation. Karl Pearson launched histogram.

In Excel, you may create a Histogram from the Evaluation ToolPak that comes as an add-in with Excel. Nevertheless, in such a case, when the info is up to date, Histogram won’t mirror the modified knowledge except it’s modified by Evaluation ToolPak once more.

On this chapter, you’ll discover ways to create a Histogram from a Column chart. On this case, when the supply knowledge is up to date the chart additionally will get refreshed.

What’s a Histogram?

A Histogram is represented by rectangles with lengths akin to the variety of occurrences of a variable in successive numerical intervals. The numerical intervals are known as bins and the variety of occurrences is known as frequency.

The bins are often specified as consecutive, non-overlapping intervals of the variable. The bins have to be adjoining and are of equal dimension. A rectangle over a bin with peak proportional to the frequency of the bin depicts the variety of circumstances in that bin. Thus, the horizontal axis represents the bins whereas the vertical axis represents the frequency. The rectangles are coloured or shaded.

A Histogram will probably be as proven beneath.


Benefits of Histograms

Histogram is used to examine the info for its underlying distribution, outliers, skewness, and so forth. For instance, Histogram can be utilized in statistical evaluation within the following eventualities −

  • A census of a rustic to acquire the individuals of assorted age teams.
  • A survey centered on the demography of a rustic to acquire the literacy ranges.
  • A research on the impact of tropical illnesses throughout a season throughout completely different areas in a state.

Preparation of Knowledge

Contemplate the info given beneath.

Preparing Histogram Data

Create bins and calculate the variety of values in every bin from the above knowledge as proven beneath −

Create Bins

The variety of values in a bin is known as the frequency of that bin.

Bin Values

This desk is known as a Frequency desk and we’ll use it to create the Histogram.

Making a Histogram

Following are the steps to create a Histogram.

Step 1 − Choose the info within the Frequency desk.

Step 2 − Insert a Clustered Column chart.

Create Histogram

Step 3 − Proper click on on the Columns and choose Format Knowledge Sequence from the dropdown listing.

Step 4 − Click on SERIES OPTIONS and alter the Hole Width to zero beneath SERIES OPTIONS.

Click and Change Gap Width

Step 5 − Format the chart as follows.

  • Click on on Fill & Line.
  • Click on on Strong Line beneath Border.
  • Choose black for colour.
  • Sort 1.5 for Width.

Format Histogram Chart

Step 6 − Modify the dimensions of the chart.


Your Histogram is prepared. As you may observe, the size of every column corresponds to the frequency of that specific bin.