Right now, the span is fourteen years, so let’s change that to ten – rewrite the value in the box, press Enter and here we go – the histogram has reflected the change and each column now covers the age span of ten years. Here you can find and adjust ‘Bin width’ as you need. To change the age range, right-click on the horizontal axis of the graph and select ‘Format Axis’. So, basically, each column covers a span of fourteen years. In the second bin, there are all the people of 26 to 40 years of age, and so on. Here, we’ve got six of them and each one covers a group of people, each group having an age range of fourteen years.įor example, the first bin includes all the people from the data table that fall within the range of 12 to 26 years of age. These are represented as columns in the graph. When a histogram is created, all the relevant data is grouped into so-called ‘bins’. How to Amend the Histogram ItselfĪnd here come a few handy tips on how to amend the histogram itself. We can also change the title of the histogram by double-clicking on ‘Chart Title’ and simply typing in the new name. You can modify it by clicking into one of the corners – on one of these circles – and move the borders of the graph area as you wish. The size of the graph is also adjustable. How to Adjust the HistogramĬonsidering the location, we can change it easily – just click into blank space within the graph area, hold the left mouse button and drag the graph where you need. Now, we’ve already got the histogram, so let’s take a look at a couple of useful options thanks to which you can customise the graph according to what you need.

Then we go to the Insert tab, click on the option ‘Insert Statistic Chart’ and choose ‘Histogram’.Ī histogram appears immediately in the spreadsheet area. Here we want to make a histogram that represents the distribution by age, so we’ll select the whole column C. How to Make a Histogram in Excelįirst of all, we need to select the area which contains the data we want to show in a histogram. In previous tutorials we’ve gone through how to make a line graph, create data bars or draw a pie chart. In Excel, we can make a neat visual representation of data through different kinds of graphs. 4 How to Change the Style and Design of the Histogram

How to insert histogram in excel