...

SAP - Advanced Excel Chart

Back to Course

Lesson Description


Lession - #494 Advanced Excel Charts – histogram Chart


A Histogram is a graphical representation of the distribution of numerical data. It's widely used in Statistical Analysis. Karl Pearson introduced histogram.

In Excel, you can produce a Histogram from the Analysis ToolPak that comes as an add- in with Excel. However, in such a case, when the data is updated, Histogram won't reflect the changed data unless it's modified through Analysis ToolPak again.

In this chapter, you'll learn how to produce a Histogram from a Column chart. In this case, when the source data is streamlined the chart also gets refreshed.

What's a Histogram?
A Histogram is represented by rectangles with lengths corresponding to the number of occurrences of a variable in consecutive numerical intervals. The numerical intervals are called bins and the number of circumstances is called frequency.

The bins are usually specified as consecutive,non-overlapping intervals of the variable. The bins must be adjacent and are of equal size. A rectangle over a bin with height proportional to the frequence of the caddy depicts the number of cases in that bin. therefore, the vertical axis represents the bins whereas the vertical axis represents the frequency. The rectangles are colored or shaded.

Advantages of Histograms
Histogram is used to check the data for its beginning distribution, outliers, skewness, etc. For illustration, Histogram can be used in statistical analysis in the following scenarios-

• A census of a country to obtain the people of various age groups.

• A survey focused on the demography of a country to obtain the literacy levels.

• A study on the effect of tropical conditions during a season across different regions in a state.

Preparation of Data
Consider the data given below.

produce bins and calculate the number of values in each bin from the below data as shown below-


The number of values in a bin is referred to as the frequency of that bin.

This table is called a Frequency table and we will use it to create the Histogram.

Creating a Histogram
Following are the way to produce a Histogram. Step 1 Select the data in the Frequency table. Step 2 Insert a Clustered Column chart.
Step 3 Right click on the Columns and select Format Data Series from the dropdown list.
Step 4 Click SERIES OPTIONS and change the Gap Width to 0 under SERIES OPTIONS.
Step 5 Format the chart as follows-

• Click on Fill & Line.

• Click on Solid Line under Border.

• Select black for color.

• Type1.5 for Width.
Step 6 Adjust the size of the chart.
Your Histogram is ready. As you can observe, the length of each column corresponds to the frequency of that particular bin.