Site icon ExcelNotes

How to Make a Histogram Chart

A histogram chart is a column chart showing the numerical data distribution. Please follow steps below to make a histogram chart:

Step 1: Select the data to create a chart;

Step 2: Click the "Insert" Tab from the ribbon;

Step 3: Click the "Histogram" command in the "Charts" area;

Step 4: A basic Histogram Chart will be created.

Step 5: Change Chart Title: Click on the title then select the words inside the box to replace with the proper ones;

Step 6: Add Data Labels: Right click on the bar of the histogram chart, in the dialog box, select "Add Data Labels".

Step 7: Change Gap Width: Double click on the bar of the histogram chart, in the dialog box, change "Gap Width".

Step 8: Axis Options: Double click on the Axis, in the dialog box, you can adjust "Bin width", "Number of Bins" etc.

Download Example

Exit mobile version