how to make a histogram in excel 2016 on pc

For making comparative histogram, we need to convert values of one field into negative values. For instance, we have included a spreadsheet of university students, containing columns for each gender, as shown in the screenshot below. I want to see the result in a chart also, so I select this Chart Output option. Launch Excel 2010, and open spreadsheet in which you want to make a histogram for your data table. I want to see my output in a new worksheet.

Or you can see the output into a new workbook.

You can also show the output in a new worksheet, by default this option is selected.

You can show your output in the same worksheet, in that case, you will select the Output range option and on the right side field, you will set the cell where you want to see the output.

In the bin range, I select values in the cells B2 to B11.

See more about different types of histogram charts in Excel. Each bar of the histogram represents the count of data values within the specified range. The true histogram chart shows the distribution of numerical data. In the Input range, I select these values from cell A2 to A41. A histogram chart is often confused with a bar chart because it displays data using bars of different heights. Or I can double click on the histogram option. You will find several Data Analysis tools in the window. Creating Histogram Using Analysis ToolPakĬlick on the Data Analysis command in the data tab. Now you find the Data Analysis command will be showing under the Analysis group of commands in the Data tab.

Analysis ToolPak check box is not selected. under Manage drop-down, Excel Add-ins is already selected.

How to make a histogram in excel 2016 on pc