You can further improve the histogram by replacing the default Bins and Frequency with more relevant axis titles, changing chart style, customizing the chart legend, etc. Now, a Frequency Distribution table is created in the specified cell address along with the Histogram chart. Then, check ‘Chart Output’ and click ‘OK’. Then, click on the ‘Bin Range’ box and select the range D2:D9 (which contains data intervals).Ĭlick the Output Range box and select a cell where you want the frequency distribution table to appear. In the Histogram dialog window, you need to specify the Input range, Bin range, and Output range.Ĭlick on the ‘Input range’ box and select the range B2:B16 (which contains Marks). In the Data Analysis dialog box, select ‘Histogram’ from the list and click ‘OK’.Ī Histogram dialog box will appear. Then, go to the ‘Data’ tab and click ‘Data Analysis’ in the Excel Ribbon. We need to specify these bins separately. In the following example, column A and B contain the data set, and column D contains bins or mark intervals.
For creating a histogram, first, we need to create a data set and then data intervals (bins) at which we want to find the data frequency. Creating Histogram using Data Analysis ToolĪnother way to make a histogram is by using Excel’s add-in program called Data Analysis toolpak. The result is shown in the following picture. If we change the number of bins to 6, the data will be grouped into 6 bins. You can change bin width, bin grouping, number of bins on the chart, etc.įor example, when we created the chart, Excel automatically made data into three-bin groupings. Here, you can further customize your axis to fit your need.
This will open a format pane on the right-hand side of your Excel window. To format the X-Axis and Y-axis of the chart, right-click anywhere on the axis and select ‘Format Axis’ from the context menu. You can add chart elements, change the colors of the bars, change chart styles, and switch rows and columns. Once you created the histogram, you can customize it to fit your need in the ‘Design’ tab of Excel. This would create a histogram with the distribution of data (marks) clubbed into bins as shown below. The histogram chart type is now available in the ‘Charts’ group of the Insert tab.Ĭlick on the histogram icon and select your histogram chart type. Select the range of cells and go to the ‘Insert’ tab. Creating a Histogram using Chartsįirst, create a dataset and select the range of cells containing the data to be displayed as histogram.įor example, let’s create a dataset for a number of students in 10 classes as shown below:
#HOW TO INSTALL DATA ANALYSIS IN EXCEL 2010 HOW TO#
Now, the histogram tool is available in Excel, let’s see how to create one. Then, check ‘Analysis ToolPak’ checkbox in the Add-ins dialog box and click ‘OK’. Select ‘Excel Add-in’ from the ‘Manage:’ drop-down at the bottom of the window and click ‘Go’. Here, you can view and manage your Microsoft Excel Add-ins. In ‘Excel Options’, Click on the ‘Add-ins’ tab on the left side. In the Excel backstage view, click ‘Options’. To install Analysis ToolPak Add-in, open the ‘File’ menu in Excel. Once the Add-in is installed, the Histogram will be made available in the list of Analysis Tools or in the charts group. To access it, you need to install Analysis ToolPak Add-in on Excel. The Histogram tool is not available in Excel by default. Now, let’s see how to create a Histogram in Excel. In Excel, you can create a histogram using the Data Analysis ToolPak or using a built-in histogram chart. A histogram, unlike a bar chart, shows no gaps between the bars.Ī histogram chart in Excel is primarily used for plotting the frequency distribution of a data set. However, Histograms are used to show distributions of data while bar charts are used to compare data. Histograms may look very similar to vertical bar graphs but they’re different. You can easily create a histogram using the Data Analysis ToolPak or the built-in histogram chart in Excel.Ī histogram is a graphical chart that shows the frequency distribution of discrete or continuous data.