To make a histogram in Google Sheets, select your numeric data, click Insert > Chart, then choose Setup > Chart type > Histogram chart in the chart editor. Sheets counts the observations and groups them into buckets automatically. These steps use Google Sheets in a desktop browser and require permission to edit the spreadsheet.
The short version
- Start with observations: Put your raw numbers in a column, optionally with a header.
- Create the chart: Select the numbers, click Insert > Chart, and choose Histogram chart under Chart type.
- Control the intervals: Open Customize > Histogram and adjust Bucket size.
- Use existing counts: Choose a Column chart when your data already consists of interval labels and frequencies.
| Your starting point | Approach | What to expect |
|---|---|---|
| Raw numeric observations | Insert a Histogram chart | Sheets calculates buckets and counts |
| A preference for keyboard controls | Find the chart command through tool finder | Choose the histogram type after insertion |
| An existing editable chart | Change its chart type | Select raw observations as its data range |
| A ready-made example | Copy Google’s histogram example | Replace the sample observations with your numbers |
| Interval labels and counts | Create a Column chart | Plots frequencies you have already calculated |
| Chosen upper bin limits | Calculate counts with FREQUENCY | Includes an extra count above the final limit |
| Explicit lower and upper boundaries | Calculate counts with COUNTIFS | Includes the lower boundary and excludes the upper boundary |
| Ordered counts for a small visual | Create a SPARKLINE | Displays columns inside a cell |
Prepare your numeric data
Enter the individual observations in a column, with an optional header above them. For example, put a measurement header in A1 and the measurements themselves in A2:A101. The native histogram uses those individual values to calculate how many observations belong in each bucket.
Choose a descriptive header so you can identify the data when editing the chart. For help organizing your labels, see how to rename columns in Google Sheets. If you need extra space for separate observations or calculated counts, add columns in Google Sheets beside the original data.
Insert your histogram
Select the cells containing your numbers, including the header if you added one. Click Insert > Chart. In the chart editor, open Setup, select Chart type, and choose Histogram chart.
Sheets calculates the frequencies and chooses buckets automatically. Each bucket groups observations within a numerical interval, so you can see how your values are distributed. Leave the automatic grouping in place if it suits your data, or adjust Bucket size using the steps below.
Fix the chart type or data range
If you already inserted a different chart, double-click it and choose Setup > Chart type > Histogram chart. If the chart uses the wrong cells, select Data range, choose the raw numeric observations, and click OK. For help with the general chart editor, see how to make a graph in Google Sheets.
Adjust the histogram buckets
Double-click the histogram to open its editor, then select Customize > Histogram. Enter your desired interval width in Bucket size. For example, a bucket size of 10 groups values into intervals 10 units wide.
Adjust Outlier percentile if you need to change outlier handling. To show boundaries between individual observations within the bars, check Show item dividers. You can use these controls directly on the native histogram without building a separate frequency table.
Add labels and chart titles
To display frequency labels, double-click the histogram and open Customize > Series. Check Data labels, then adjust Position and the label formatting as needed. These labels let you read counts directly on the chart.
Open Chart & axis titles under Customize to edit the titles. Give the chart a title that identifies your observations, and use axis titles to clarify the measured values and their counts. You can also adjust its appearance through Chart style, Legend, Horizontal axis, Vertical axis, and Gridlines.
Chart data you have already counted
If your spreadsheet already contains intervals and their frequencies, plot those counts with a column chart. Put the interval labels in the first column and the counts in the next, keeping the intervals in numerical order. Include intervals with zero observations so you preserve gaps in the distribution.
Select both columns, click Insert > Chart, and choose Setup > Chart type > Column chart. Use the interval labels for the horizontal axis and the frequencies for the series. This plots your existing counts; the native histogram calculates its own counts from individual observations.
Keep the intervals equal in width when constructing this frequency chart. Your chart may retain spacing between the columns, even though they represent numerical intervals. If you want automatic histogram binning, select the individual observations and create a native histogram instead.
Calculate counts for specific intervals
Use FREQUENCY when you want to supply upper bin limits yourself. With numeric observations in A2:A101, enter ascending upper limits in B2:B6 and leave C2:C7 available for the results. Select C2 and enter this formula:
=FREQUENCY(A2:A101,B2:B6)You get one more count than the number of supplied limits. That extra count represents observations above the final boundary, so add a label in B7 identifying those values. Plot the bin labels and counts using the column-chart steps above, retaining or deliberately accounting for the overflow count.
For explicit lower and upper boundaries, put a lower boundary in B2 and an upper boundary in C2. Select D2 and enter the following formula, which counts values greater than or equal to the lower boundary and less than the upper boundary:
=COUNTIFS($A$2:$A$101,">="&B2,$A$2:$A$101,"<"&C2)Repeat the calculation for consecutive bins, with the final upper boundary above your largest observation. Create interval labels and plot those labels with their counts as a Column chart, including zero-count intervals. These formula examples assume populated numeric observations and use English-style comma separators.
Frequently Asked Questions
How can you insert a histogram using the keyboard or menu search?
Select your numeric data, then press Alt + / on PC or ChromeOS, or Option + / on Mac to open the tool finder. You can also click Search in the toolbar or select Help > Search the menus. Search for chart, select the chart-insertion command, then choose Setup > Chart type > Histogram chart. The shortcut opens the tool finder; you still choose the chart type yourself.
Can you put multiple datasets in one histogram?
Yes, additional numeric columns can supply additional series in a native histogram. Select the columns containing those observations when creating the chart.
How do you use Google’s histogram example?
Open Google’s Histogram charts help page and click Make a copy under Examples. Sign in if requested, create your copy, and replace the example observations with your numbers. You need a Google Account to retain an editable copy. If your replacement data occupies a different range, double-click the chart and change Setup > Data range.
How do you make a miniature distribution chart inside a cell?
Calculate ordered bin frequencies first, then enter =SPARKLINE(C2:C7,{"charttype","column";"ymin",0}) in another cell if your counts occupy C2:C7. Resize the cell to enlarge the visualization. This creates an in-cell column chart without automatic histogram binning or full chart labels.











