Google Sheets has a built-in histogram chart type for showing numeric data across buckets or ranges. It works in the browser and can use one or more numeric columns, with the first row used as an optional legend label.
Steps
Enter your data in one column
Put all your values in a single column (e.g., A1:A100). Add a header in A1 if you like (e.g., "Score"). Each cell below should contain one numeric value.
Select your data column
Click the header of your data column (A) to select the entire column, or click A1 and Shift+click the last value to select just your data range.
Insert a chart
Go to Insert → Chart. The Chart Editor panel opens on the right side of the screen.
Change the chart type to Histogram
In the Chart Editor, click the Chart type dropdown and choose Histogram. Google Sheets redraws the chart as a histogram with automatic buckets.
Adjust bin size
In the Chart Editor, click the Customize tab → expand Histogram → change Bucket size to your desired bin width (e.g., 10 for test scores, 5 for finer resolution). You can also enable Show item dividers to add tick marks between bins.
Add axis labels and title
Still in Customize → expand Chart & axis titles. Add a Chart title (e.g., "Distribution of Test Scores"), an X-axis title (your variable name), and a Y-axis title ("Frequency" or "Count").
Customizing the histogram
- Bucket size — controls bin width. Smaller buckets show more detail; larger buckets show the overall shape. Start with
√nbins as a rough guide (for example, √100 ≈ 10 bins for 100 values, so bucket size ≈ range/10). - Outlier percentile — set a percentage to exclude extreme values from the histogram range. Useful when one or two outliers compress the main distribution.
- Bar color — Customize → Series → change fill color to match your document theme.
- Legend — usually not needed for a single-series histogram; turn it off in Customize → Legend → Position → None.
Downloading the chart
Right-click the chart → Download → choose PNG image (for slides and documents) or PDF file (for scalable web and print use). PDFs are also available.
Google Sheets histogram limitations
- Bin boundaries are controlled only by bucket width, not by specific start/end values
- Y axis always shows frequency (count); you can't switch to density or proportion without additional columns
- You can't overlay a normal distribution curve
- Google Sheets is convenient, but chart formatting can vary when collaborators duplicate or edit the file
When to use an online histogram maker instead
For presentations, reports, or publication-quality charts with more control over bins and Y-axis type, the free online histogram maker is faster — paste your data, drag the bin slider, and export PNG or PDF without much setup.
FAQ
Why does my Google Sheets histogram show no data?
The most common cause is that the data column contains text or empty cells mixed with numbers. Select the column, go to Format → Number → Number to convert all values to numeric format, then delete any remaining text entries.
Can I make a histogram in Google Sheets from data in multiple columns?
Yes, Google documents optional additional numeric columns for histogram data. If you want one combined distribution instead of separate series, create a helper column with =FLATTEN(A2:C100), then chart that column.
How do I remove the gap between histogram bars in Google Sheets?
Google Sheets histogram bars have no gaps by default (unlike regular bar charts). If you see gaps, you may have selected a Bar Chart instead of a Histogram. Go back to Chart type and reselect Histogram.
References
- Google Docs Editors Help: Histogram charts
- Google Docs Editors Help: Types of charts and graphs in Google Sheets
How this guide is reviewed
This guide is maintained by the ChartsMakers Editorial Team and reviewed for statistical accuracy, product behavior, and clarity. Sources used for factual checks are listed in the References section. See our editorial policy.