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. Scott’s normal reference rule tries to minimize the bias in variance of the Pareto chart compared with the data set, while assuming normally distributed data.4 How to Change the Style and Design of the Histogram To change this value, enter a decimal number into the box.įormulas used to create histograms in Excel 2016 Underflow bin Check the box to create a bin for all values below or equal to the number in the corresponding box. To change this value, enter a decimal number into the box. Overflow bin Check the box to create a bin for all values above the number in the corresponding box. Number of bins Enter the number of bins for the Pareto chart (including the overflow and underflow bins).

The bin width is calculated using Scott’s normal reference rule.īin width Enter a positive decimal number for the number of data points in each range. Tip: To count the number of appearances for text strings, add a column and fill it with the value “1”, then plot the Pareto chart and set the bins to By Category.Īutomatic This is the default for Pareto charts plotted with a single column of data.

How to insert histogram in excel