How to create a histogram in excel 2013

There is people got difficult to create a histogram in excel 2013. Actually, how to create a histogram is easily. You just have to create a 2-D Clustered Column and decrease the gap width to zero percent. Check the details below!

How to create a histogram in excel 2013

1. Select all table

2. Click “Insert”

3. Click “Insert column chart” and select 2-D Clustered Column.

4. Click on chart area and then right-click.

5. Click “Format Chart Area…”
6. Click “Arrowhead” and select “Series …..”

7. Decrease the gap width until 0%

How to change the data series color of histogram

1. Click on data series
2. Click “FORMAT”

3. Click “Shape fill”
4. And you can select the color
5. Or you can right click on chart area and then click “Format Chart Area…”. And select “data series option”. Next you can change the color fill and border.

On “FORMAT” ribbon, you can change shape style, word art style, arrange or size of your histogram easily.