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.

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.


Rated #1 Excel Dashboards, Scorecards and KPIs Reports

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

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.

Mr Dashboard

(Pricing is available on the next page)