Excel histogram bin range

This example teaches you how to make a histogram in Excel.

1.

Histogram in excel 2013

First, enter the bin numbers (upper levels) in the range C4:C8.

2. On the Data tab, in the Analysis group, click Data Analysis.

Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

3.

Select Histogram and click OK.

4. Select the range A2:A19.

5. Click in the Bin Range box and select the range C4:C8.

6. Click the Output Range option button, click in the Output Range box and select cell F3.

7.

How to make a histogram in excel from a frequency table

Check Chart Output.

8. Click OK.

9. Click the legend on the right side and press Delete.

10. Properly label your bins.

11. To remove the space between the bars, right click a bar, click Format Data Series and change the Gap Width to 0%.

12.

How to make a histogram in google sheets

How to make a histogram in excel with two sets of data

How to create a histogram in excel with bins

How to make a histogram in excel from a frequency table

How to make a histogram in word

To add borders, right click a bar, click Format Data Series, click the Fill & Line icon, click Border and select a color.

Result:

If you have Excel 2016 or later, simply use the Histogram chart type.

13.

Select the range A1:A19.

14. On the Insert tab, in the Charts group, click the Histogram symbol.

15

how to make a histogram in excel with two sets of data

how to create a histogram in excel with bins