How to use the Histogram in Excel (Step By Step Guide)

In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure that the Analysis Tool Pak Add-in is installed on your system.

Using the Histogram in Excel:

If you’re planning to use the Histogram tool, then there are certain things that you need to keep in mind. You got to ensure a point that the Analysis Tool Pak Add-in is installed in your system. The most important steps:

Steps to Install histogram in Excel:

In order to create a histogram in Excel, you need to start with the installation Process. First, start with installing of the Analysis Toolpak add-in. This Toolpak add-in will enable you to create the histogram quickly. This happens when you take the data and the data range (bins) as the inputs.

To start with the installation of the Histogram Data Analysis Toolpak add-in:

  • Click on the File tab and then select the ‘Options‘.
    Excel option menu
  • Excel Options dialog box, select the Add-ins from the navigation pane.
    Excel Option & Add - Ins Select
  • In the Add-ins dialog box, you have to select Analysis Toolpak and then click OK
    Excel Option & Add - Ins Select - 2
  • This will help you install the Analysis Toolpak. And then you can easily have the access to it in the Data tab of the Analysis group.
    Analytics ToolPak

Now, How to create a Histogram in Excel by using Data Analysis Toolpak

Once you have the access to the Analysis Toolpak enabled, you can use it for creating a histogram in Excel.

Suppose you have got a dataset which is shown in the below image. It contains the marks. i.e. (out of 100) of the 40 students in a subject.

data analysis tab

In order to create a histogram while using this data, we need to create the data intervals from where we would obtain the Data. The place from where you would want to find the data frequency. These are called the bins.

Read More:

With the above dataset, the bins can be termed as the marks intervals.

  • You will need to specify these bins separately in an additional column which is shown below:

Students & mark in excel

Now that we gathered all the data in the place, let’s see how we can successfully create a histogram using this data:

  • Visit the Data –> Go to Analysis –> Go to Data Analysis.
    data analysis tab
  • In the Data Analysis dialog box, select the Histogram in Excel from the list.
    data analysis tab1
  • Click OK.
  • When in the Histogram dialog box:
    • Firstly, you’ve to Select the Input Range (i.e. all the marks in our example)
    • Then select the Bin Range (cells D2:D7)
    • Leave the Labels checkbox unchecked (and you’ll need to check it only if it is including the labels in the data selection).
    • You need to Specify the Output Range in case if you wish to get the Histogram in the same Worksheet. Or else, you even get and can select the option for New Worksheet/Workbook, if you want to get it in a separate worksheet/workbook.
    • Select the Chart Output.

You can analyze your information i.e. the Data and then later show it in a histogram bar chart. This is a column chart that displays frequency data by utilizing this Histogram the bar chart tool which is actually the Analysis Tool-Pak used in MS Office Excel. In order to make a Histogram bar chart, you would need to organize the info which is basically the data individually in two columns on the worksheet. These columns should be containing the input data and the bin numbers.

Learn Microsoft Word Course Online | 44+ Course Lessons | 4+ Hrs Video | Price: $99

The input information or input file, computer file or the input data} is the data that you wish to investigate or Analyze by utilizing or making use of the Histogram tool. Bin numbers are called to be or considered to be the numbers that represent the intervals that you have always wished for your Histogram chart tool to use for the measurement of the {input information, input file and input Data} within the data analysis.

While you’re using the Histogram tool, the Excel may count the quantity of information the number of Data points in each & every data bin. Now, this Knowledge/information point or the Data Point is enclosed in an exceedingly explicit data bin if the quantity is bigger, the number is greater than that of the lowest bound and further equal to or less than that of the Largest bound maintained for the Data Bin. If you plan to omit the bin range, then here Excel will be creating a collection of equally distributed bins between the minimum and most of the Maximum values of the input Data.

The output of the histogram which is taken, it’s analysis gets displayed on a complete new worksheet (or this could be called a new workbook) and shows that a histogram table and a column chart that reflects the data in the histogram table.

Pre-Registration Open

Power BI Dax

Related Tutorials

Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018