PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE HISTOGRAM CHART IN EXCEL

INTRODUCTION

CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.

Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.

Excel provides us with a variety of charts and graphs to make our life easier. Although any chart can be used for any type of data, even then there are certain types which are apt for a particular type of data.

This is a standard excerpt for the charts.

Now, in this article , we will discuss about the HISTOGRAM CHART which are specifically designed to show the frequency of the data in certain bins.[Intervals]. Histogram is a statistical chart useful in statistics.

The histogram chart shows the bars showing the frequency in a particular interval.

Every interval is represented by a column and the area of column represents its frequency.
It simply shows the data pattern of a data.

 

 

WHEN TO USE HISTOGRAM CHARTS

HISTOGRAMS are used at many places.

HISTOGRAMS shows the data distribution. It shows the frequency of any particular value.

Histograms are most helpful in random surveys. For example, if we want to know the random temperatures of a group of human beings.

Histograms are also used in photography. It shows the tonal distribution of the image.

So, when we have a study in which we need to find out the most frequent data or least frequent data, we can make use of histograms.

 

BUTTON LOCATION FOR SUNBURST CHARTS

The button for column chart is found under the INSERT TAB >CHARTS SECTION under the button INSERT STATISTICAL CHARTS >HISTOGRAM CHART. The location is shown in the picture below.

button location for histogram
EXCEL:BUTTON LOCATION FOR INSERTING HISTOGRAM CHARTS

STEPS TO INSERT A HISTOGRAM CHART IN EXCEL

EXAMPLE DETAILS

We can demonstrate the chart using an example.
We are taking the example of a class of 100 students. Let us find out the distribution of the marks of the class, which can give us a wider view of the performance.
The chart shows the data.
MARKS OF 100 STUDENTS
6598917573
62611007751
8056716393
9777675057
5981927977
6075706253
8886556695
8176785671
6354929692
9369966488
9895789580
10079637189
5255897468
6780947666
9197807569
9777675057
5981927977
6075706253
8886556695
8176785671

The procedure to insert a HISTOGRAM chart are as follows:

STEPS TO INSERT A HISTOGRAM CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.[We have already created in the form of table above]
  • Refer to our data above, we have the marks of 100 students for a class.
  • Select the complete table.
  • Go to INSERT TAB> CHARTS> and click the HISTOGRAM CHART under  INSERT STATISTICAL CHARTS BUTTON as shown in the BUTTON LOCATION above and in the following picture for reference.
  • The chart will be created and shown to you as the following figure.
 
 The complete process is shown in the animated picture below.

 

CREATE HISTOGRAM CHART IN EXCEL
EXCEL:STEPS TO CREATE HISTOGRAM CHART

So , we have successfully created a HISTOGRAM CHART.

We can see that a histogram has been created automatically. It is showing the data in the three columns which we can call as the bins. So these columns tells about the frequency of the numbers falling inside the given bins.

Let us change the bin size and check the chart after setting the bins.

CONFIGURING THE BIN IN HISTOGRAM CHART

The BIN is the interval which we use in statistics. The interval is like a class such as 16-20 it means all the data inputs between the range 16-20 will fall in this class.
We saw that the chart created took the bin size automatically but it is quite possible that we need different bin size.
We want the bin size of 10.

Follow the steps to configure the bin size.

  • Right Click on the horizontal axis >FORMAT AXIS>AXIS OPTIONS [ON THE RIGHT]

  • The FORMAT AXIS BOX will open on the right.
  • Go to the AXIS OPTIONS.
  • Go to BINS.
  • Choose the type of bin as per requirement.

Bins can be adjusted by many ways. For example,

by

  • CATEGORY [ DEFAULT AS SHOWN ABOVE]
  • BY WIDTH [WIDTH AS VALUE]
  • NUMBER
    OF BINS[ THE VALUES WILL BE DIVIDED IN A SPECIAL PATTERN AND BINS WILL
    BE FORMED. THE NUMBER WILL BE INCLUDING OVERFLOW BIN AND UNDERFLOW BIN]
  • OVERFLOW BIN [ ALL ABOVE VALUES WILL BE PUT IN THAT]
  • UNDERFLOW BIN[ ALL LOWER VALUES WILL BE PUT IN THAT]
For our example ,we will use the fixed width of the bins as 10.
 
HISTOGRAM CHART IN EXCEL
EXCEL:FINAL HISTOGRAM CHART
So, we have created a histogram. Now look at the histogram , it has created 10 bins. The bins started from around 50 as there is no value less than 50. The bins which has no values are empty.
Similarly we can customize the histogram as per our requirement.
 

NOTE:CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC.

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: