How to Make an Excel 2007 Histogram

In this video tutorial we will show you how to make an excel histogram.


In order to create an excel histogram, open an excel document. Enter data into the cells. Then go to the “Insert” tab. Click “column” and select 2-D column.

Select the column type

Then right-click on the created chart and click “select data”.

Select the data

Select the data you want to add. Then in the “Select data source” window press “Edit”.

Edit the column

Select the data that must be added to the “axis labels” and click “ok”. Then press “ok” to close the window. Select the legend text on the right and press “delete” key. Then go to the “Design” tab and choose another chart style among “Chart Styles”.

Choose Chart styles

When done, go to the “Chart Layouts” and choose “layout 8”.

Choose layout type

Then right-click on the left axis and select “Format axis”.

Format the axis

In the appeared window change the “major unit” and “Maximum” options. Enter the bottom and the left titles. Now your histogram is ready. Save the document.