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
0 kommentar(er)
