How To Create Histogram In Excel

Steps to Make Histogram Chart in Excel

Develop a histogram, often called the Pareto graph or chart, in order to graphically show the actual distribution together with frequency for your data within an Excel spreadsheet. Histogram chart application is not found in Excel automatically, you could gain access to this following launching Analysis ToolPak which is an Excel add-in.

Download All Products Today And Save 60% >>

Business Management Software

Rated #1 Excel Dashboards, Scorecards and KPIs Reports

Download Free Templates for Sales, HR, Finance, Marketing, Quality...

As soon as set up, Histogram application is available within the Analysis Tools from Data Analysis. You are able to establish the particular input as well as output alternatives while using Analysis Tool after which pick a display style to make a histogram out of your Excel data.


Create Histogram in Excel
Histogram Chart Example in Excel


Select the box at the side of Analysis ToolPak then click on the OK option. Simply click Yes to set up Analysis ToolPak in cases where prompted.

Type in bin figures with ascending order to the following column. Name the very first cell on the column Range.
Click the Data tab thereafter click on the Data Analysis inside the Analysis collection to start Data Analysis.

Choose Histogram through the checklist below Analysis Tools and after that click on the OK to start the Histogram.
Type in the actual cell range for the input information in to the Input Range area. As an example, type in A2:A9 and after that type in cell range for the bin information in to the Bin Range area. In case you incorporate your own column titles inside the selected range, select the box alongside Labels.

Pick one of many choices within Output Alternatives. For instance, click on the button adjacent to New Worksheet to include the histogram into a brand new Excel sheet.

Check out a minimum of one in the boxes below Output Alternatives. Check Pareto – which is type of sorted histogram chart to indicate your info by frequency. Select Cumulative to add the cumulative line with your graph.

Select Chart Output to generate the embedded histogram graph or chart.
Choose OK to make your own histogram chart in line with the actual input plus output choices you decided on.


* indicates required

Rated #1 Excel Dashboards, Scorecards and KPIs Reports

Here is How to Easily Track your KPIs in Excel

Free Business Management Templates