How to Create a Histogram in Excel

Step-by-Step Guide

1. 1

   Step 1: Navigate to the "Excel Add-ins" dialog box.

   You can do this from the main Home screen once you've opened the program.
   
   Click Options on the File menu.
   
   Then, click Add-Ins in the navigation pane.
   
   In the Manage list, choose Excel Add-ins.
   
   Then, click Go.
2. 2

   Step 2: Select the Analysis ToolPak Add-in.

   Once you're in the Add-Ins dialog box, select the Analysis ToolPak check box under Add-Ins available, if it is not already selected, Then, click OK.
   
   Note that the Analysis ToolPak Add-in will not appear in the Add-Ins dialog box if it is not already installed on your computer.
   
   If you do not see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup.
   
   Add the ToolPak to the list of installed items. , This is where you can check whether the Analysis ToolPak is already installed on your computer.
   
   From the Home screen, click the Microsoft Office button.
   
   Then, select Excel Options.
   
   Click Add-Ins from the navigation pane.
   
   Pick Excel Add-ins from the Manage list.
   
   Then, click Go. , In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available has been selected.
   
   Then, click OK.
   
   This should activate the Analysis ToolPak—and thus the Histogram function—on your computer., Organize your data into two adjacent columns on the spreadsheet.
   
   Fill the left-hand column with your "input data," and the right-hand with your "bin numbers."Input data is the set of numbers that you want to analyze with the Histogram tool.Bin numbers represent the intervals that you want the Histogram tool to use for measuring and analyzing the input data.
   
   For instance, if you want to separate grades into categories of A, B, C, D, and F, you could make bins for 60, 70, 80, 90, and
   100., The process is consistent for all versions of Excel released since
   2007.
   
   If you are using an earlier version of the software, then you will need to follow a slightly different process.
   
   In Excel 2013, Excel 2010 and Excel 2007: navigate to the Data tab.
   
   Then, click Data Analysis in the Analysis group.
   
   For Excel 2003 and earlier versions: select Data Analysis from the Tools menu.
   
   If there is not a Data Analysis option under the Tools menu, then you may need to install the add-in. , Once you're in the Data Analysis dialog box, find Histogram listed amid the other analysis tools.
   
   Then, click OK.
   
   This will open the Histogram dialog box. , The input range is the range of cells that contain data.
   
   If your input data is a set of ten numbers, and you have copied it into the A column (from A1 to A10), then enter your data range as A1:
   A10.
   
   The bin range is the range of cells that contain your bin numbers.
   
   If you have four "bins" at the top of Column B, then enter your bin range as B1:
   B4. , Under Output Options, click New Workbook.
   
   Then, select the Chart Output check box. , Excel will generate a new workbook with a histogram table and an embedded chart.
   
   The chart should be a column chart that arranges the data from your histogram table.
3. 3

   Step 3: Navigate to the "Excel Add-ins" dialog box.

4. 4

   Step 4: Select the ToolPak.

5. 5

   Step 5: Enter your data.

6. 6

   Step 6: Open the Data Analysis box.

7. 7

   Step 7: Select "Histogram."

8. 8

   Step 8: Select the input range and the bin range.

9. 9

   Step 9: Check the chart output box.

10. 10

    Step 10: Click OK to finish the job.

Detailed Guide

About the Author