How To

How to make Histogram in Excel

Spread the love

Wondering, how to make Histogram in Excel? Wondering, how you could be perfect in using MS Excel?

Stop wondering, read thoroughly this article and implement the methods. You don’t need to wonder further for the same question 🙂

A histogram is similar to a bar graph, but not exactly the same. In a histogram, only one variable is in use while in a bar graph, two variables are used. The histogram is the most used way for statistical data. It is the representation of numeric data in the form of rectangles with only one variable in use. A histogram is very useful fo frequency-based problems, where your value comes under a certain range. In a histogram, we make the use of bins to allow the width of the range. In MS Excel, we can easily show all these kinds of statistical data very easily, such as all types of graphs including a bar graph, pie chart, photograph, line graph etc.

You might also be interested in:- How to Merge Cells in Excel

The histogram in comparison is a bit trickier in the older version of MS excels which is way easier in new versions. In this article, I am going to cover how to make a histogram, for older and newer versions of MS Excel. This article comprises of various method of making a Histogram from MS Excel, providing all the details of each method including advantages and disadvantages. So, without any further delay, let’s start with the article.

Creating Histogram in Microsoft Excel

Microsoft Excel is spreadsheet software that supports every popular Operating system or Devices. It can perform calculations, store data, create tables and even do Macro programming. It contains cells for creating tables or spreadsheets. In these cells, you can store any type of values. For further explanation and making the data representation good, you can add various charts or histograms to the excel spreadsheet.

In this article, I will be showing you how to create this histograms from the data of your Excel spreadsheet. I will cover not one but two methods to easily make histogram in Excel. In this first method, I will show you to make histograms using an inbuilt feature in MS Excel 2016 and in the latter one I will show how to do the same thing using an Add on to your Excel software. The second method can be followed using any version of MS Excel. If you want to learn how to update your MS Excel on your Computer follow this WikiHow Website. So if you are using an older version of Microsoft Excel directly scroll down to the last method. So let’s jump directly to our first method.

Using In-built feature of Excel 2016

Older MS Excel versions do not have a direct option of making a histogram. Users those who are using MS Excel 2016 have the advantage of having a histogram chart as an inbuilt option. This inbuilt histogram option brings you many features to make your histogram look perfect and correct. You don’t need to create any extra column for the bin. Follow the steps mentioned below to easily make histogram in your Excel spreadsheet.

  • Firstly, open MS Excel 2016 from your desktop.
  • Secondly, create or open a datasheet for which you want to make a histogram chart.
  • Select a particular column for which you want to make a histogram.
  • Go to the “Insert” tab from toolbar.
  • Select “Insert statistic graph” from the “charts” section of your toolbar.
  • Choose the type of histogram you want.

inbuilt feature for histogram Excel 2016

  • Right-click on the histogram chart and click “Format Axis” to do the changes.
  • In the “Format Axis” screen you can see many options under “Bins” such as “By category”, “Automatic” etc.
  • Do the changes according to your requirement.
  • It will show you the histogram chart above the criteria mentioned.
  • And if you want the vice versa of this, check the box next to “Underflow bins” and write the criteria. It will show the histogram below the criteria mentioned.
  • Lastly, right-click again on the histogram chart, click “Add data labels” and click “Data length” to see the length of each bin.

So, your histogram is fully prepared now. This method is the easiest but comes with a disadvantage that only those who are having Excel 2016 are benefitted with this method. Those who are using other versions, “Data Analysis tool pack” as add-ons will solve your problem. So, don’t lose hope and keep scrolling.

Similar Articles you might like:- [FIXED] Your Windows License will Expire Soon

Using Add-ons with any version of Excel

Data analysis tool pack in MS Excel is very useful for data analysis of engineering which includes histogram, Fourier analysis etc. Here you need to create a separate column assigning the bin of your own choice. To install Data Analysis add on to your Excel software click on “Go” next to “Manage- Excel add-ins”. Check the box next too “Analysis tool pack”, click “ok”, click “Yes” for installation.

This method is applicable to all versions of MS Excel. To create a histogram with the help of data analysis tool pack, follow the steps in continuation very carefully.

  • Firstly, open MS Excel on your Device.
  • Enter the values in a single column for which you want to create a histogram.
  • Create another column assigning the bins.
  • The bin width can be irregular too.
  • Select the “Data” tab from the toolbar of the Excel window.
  • Select “Data Analysis” which you can see at the right side of the toolbar.

Data Analysis addon on Excel

  • Now click “Histogram” from the Data analysis window and click “Ok”.
  • In the Histogram window, click the text box next to “Input Range” and select the complete column for which you want to make the histogram.
  • Now click the text bar next to “Bin Range” and select the data of the column in which you have assigned the bins.
  • Select “Output Range” and click the text bar next to it and select a very big blank area of your Excel sheet.

Outpur range and bin range to create histogram on Excel

  • Check the box next to “Chart Output” and click “Ok”.

So now you can see your histogram. If you want some changes in the gaps between the bars, right-click on the histogram, go to “Format chart area” and do the changes. So, that’s all for this method.

Finally creating Histogram on Excel

So that’s the end of all our method. You must have created a histogram on your Excel spreadsheet by now. These methods are more than enough to create a histogram of data present on your Excel spreadsheet. I hope you have successfully created a histogram by now. Again if you have just read the article and not created the histogram of your data. I recommend you to do so while reading the steps, so as to avoid any mistakes.

You might also like this:- BlueMail for PC: Install on Windows 10/8/7

So that’s it. You have successfully learned ‘How to make Histogram in Excel’ using not one but two different methods. Both the methods mentioned above are working at the time of writing this article. I’ll update it if there comes any change in any of these methods. If you are having any difficulties or doubts or queries following any of the above-mentioned methods, feel free to ask me in the Comments section below. I hope now you don’t have to look anywhere else to know ‘How to make Histogram in Excel’ on the Internet.

About the author

Bhupinder Singh

I'm a programmer. I basically write about tech and programming languages. I'm currently pursuing B.tech in Information Technology in Bhopal. I'm a geek and a self-learner. I love python. ;-)

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.