Lesson 270: Histogram in Excel

In this article, I will show you how to create a chart in Excel.

How to create a chart in Excel

1. First, enter the number in the range C4:C8.

2. On the Data tab, select Data Analysis.

3. Select Histogram and click OK.

4. Select range A2:A19

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

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

7. Check the Chart Output.

8. Press OK

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

10. Label your bins.

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

12. To add a border, right-click a bar, click Format Data Series, click the Fill & Line icon, click Border, and choose a color.

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

13. select range A1:A19

14. On the Insert panel, select the Histogram symbol.

15. Click on Histogram.

Result

16. Right-click the horizontal axis, and then click Format Axis.

17. Determine the bins of the chart. I will use the same bins as before (see first image on this page). Bin width : 5. Number of bins : 6. Overflow : 40. Underflow : 20.

Result

In addition, you can also view many other excel articles here.