In this tutorial, I covered how to make a histogram in Google Sheets. You can then make edits to the chart type, data range, or any of the other chart settings available in the Chart Editor and your chart will update to reflect the changes SummaryĮxample Spreadsheet: Make a copy of the example spreadsheet There is no standard way to calculate how many classes you need, but a good rule of thumb is to take. The first step is to divide your distribution into classes (or bins ), which are, in effect, containers for your individual scores. The Chart Editor for that graph will open. You could just use our easy histogram maker, but if you want to do the job by hand, follow these instructions.
To show the data in descending order of frequency, click Pareto (sorted histogram). Under Output options, choose an output location. Under Input, select the input range (your data), then select the bin range. Click Data > Data Analysis > Histogram > OK. To edit a histogram chart you’ve already created, first open the Chart Editor for that graph by selecting the chart and clicking on the 3 dot menu icon in the corner of the chart.įrom the menu that appears, select Edit Chart. On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column. Your chart will update to a histogram Editing A Histogram To turn this chart into a histogram, click on the Chart Type dropdown menu and select the Histogram option from the bottom section in the menu Step 4 Open the Insert menu, and select the Chart option Step 3Ī new chart will be inserted as a floating element above the cells, and the Chart Editor sidebar will appear with options to edit the chart.
Select the data range you want to plot Step 2 To insert a Histogram in Google Sheets, follow these steps: Step 1