Google Sheets Distribution Charts: Types and Setup

A Google Sheets distribution chart is usually a histogram: it groups numerical values into ranges, or bins, and shows how many observations fall in each range. To create one, select your numeric data, choose Insert > Chart, then set Chart type to Histogram in the Chart editor.

What a distribution chart shows

Distribution describes how a set of values is spread out: where values cluster, how wide the range is, whether the data is lopsided, and whether unusually high or low observations appear. A histogram makes those patterns visible by dividing a numerical scale into adjacent intervals and drawing a bar for each interval. The bar height represents the number of observations in that range.

For example, a teacher could chart exam scores to see whether most students scored in the middle, whether scores cluster near the top, or whether the class has two distinct groups. A shop could chart delivery times to understand the typical wait and how often delays occur. A histogram is useful when individual observations matter less than the overall pattern.

In Sheets, Histogram is a built-in chart type. The phrase distribution chart can also refer more broadly to visualizations such as box plots, density curves, or dot plots. Sheets does not offer a dedicated box-and-whisker chart type in its standard chart menu, so a histogram is generally the most direct native option for showing a numerical distribution.

Choose the right chart for the question

A histogram works with numeric measurements that can be grouped into ranges, such as ages, prices, response times, or test results. It is not the right default for a list of named categories. If you need to compare sales by product or counts by department, a column chart or bar chart is usually clearer because each bar represents a distinct category rather than a continuous interval.

Use a histogram to see the shape and spread of one numerical variable.
Use a column or bar chart to compare separate categories, such as counts by region.
Use a scatter chart to examine the relationship between two numerical variables, such as height and weight.
Use a line chart when the order of values matters, especially for changes over time.

A histogram can be made separately for each group, but overlaying several distributions is not as straightforward as comparing series in a regular column chart. If the main question is how two groups differ, consider making side-by-side histograms with the same bin boundaries or summarizing the groups with a table and a suitable comparison chart.

Create a histogram in Google Sheets

In Google Sheets in a web browser, put the numerical observations in one column, with a clear heading at the top. Avoid including totals or text notes among the values. Then create the chart:

Select the data range, including its heading if present. For example, select A1:A101 if A1 is the heading and A2:A101 contain 100 measurements.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually on the right.
In the Chart editor’s Setup tab, open the Chart type list and select Histogram. If Sheets guessed a different chart, changing this setting is enough to switch types.
Check that the selected range contains the intended numeric values and that the heading is treated as a label rather than an observation. Adjust the data range in Setup if needed.
Open Customize to refine the chart title, axis titles, and histogram settings. Click outside the editor when finished; the chart remains on the sheet and can be moved or resized.

The chart updates when the source values change, provided those values are still within its selected range. If new rows are added below the range and do not appear, edit the data range in Setup to include them. To keep future additions easier to manage, select a suitably broad column range when creating the chart, while making sure it does not include unrelated numbers farther down the sheet.

Understand bins and select a useful width

Bins are the intervals represented by histogram bars. The number and width of those intervals affect the story the chart tells. Very wide bins can hide useful structure: a group of values near one end may blend into a broad bar. Very narrow bins can make ordinary random variation look like a collection of meaningful spikes, especially when the dataset is small.

Sheets can choose bins automatically, which is a reasonable starting point, not a guarantee that the grouping best answers your question. In the Chart editor, open Customize and look for the Histogram options. The Bucket size setting lets you specify a bin width. For measurements recorded in whole units, a width of five might produce ranges such as 0–5, 5–10, and 10–15, depending on the data and chart boundaries.

Choose a width that is meaningful in the context of the measurement and lets a reader distinguish the broad pattern. For a small set of scores, bins of five points may be easier to interpret than bins of one point. For thousands of transaction amounts spread over a large range, a wider interval may be more readable. Try a couple of reasonable widths and see whether the overall conclusion changes; do not choose a width merely because it makes the chart look dramatic.

Bin boundaries matter when comparing charts. If two groups use different widths or starting points, differences in bar heights may reflect the grouping rather than the underlying data. Apply the same boundaries to both groups when making a fair visual comparison.

Build and check a frequency distribution

A frequency table lists the count in each range and can help you verify what a histogram is showing. In Sheets, the FREQUENCY function returns counts for specified upper limits, followed by a count for values above the last limit. This is useful when you want explicit numbers alongside the chart or need to control the intervals carefully.

Suppose A2:A11 contains the ten values 12, 15, 18, 21, 22, 24, 27, 29, 31, and 37. Put the bin upper limits 19, 24, 29, and 34 in C2:C5. With the observations in A2:A11 and the upper limits in C2:C5, enter =FREQUENCY(A2:A11,C2:C5) in D2. Sheets returns five counts in D2:D6: 3 values at or below 19, 3 above 19 through 24, 2 above 24 through 29, 1 above 29 through 34, and 1 above 34. The counts add to 10, matching the number of observations.

FREQUENCY uses upper limits, so a value equal to a limit belongs in the bin ending at that limit. Its final returned count has no upper limit. Leave enough space below the formula for the results to appear, and do not type other data into the output cells. If you use the table to make a chart, be clear about whether the chart is showing counts or another measure such as percentages.

Format the chart so it is readable

A good histogram tells a reader what was measured and in what units. Use Customize > Chart & axis titles to add a specific chart title and, where useful, axis titles. For example, a title such as Delivery time for May is more informative than Chart 1; an axis title such as Days explains the horizontal scale. The vertical axis normally represents the number of observations.

Keep the visual treatment restrained. A single series usually needs no legend, and excessive colors can distract from the distribution. If you change the chart background or bar appearance, preserve enough contrast to distinguish adjacent bars. Check that axis labels are not clipped and that the chart is large enough to show the interval labels without crowding.

When the audience needs exact values, include a frequency table near the chart rather than relying on visual estimates. A histogram communicates shape well, but a bar height may not tell a reader the precise count at a glance. Also state the data period and sample size when those details affect interpretation.

Read the shape without overclaiming

Look first for the broad pattern. A roughly balanced mound suggests values are concentrated around a middle range; a long tail to one side indicates skew; separated clusters can suggest distinct subgroups or processes. A solitary bar far from the main group may be an unusual observation, but the chart alone cannot tell you whether it is an error or a genuine event.

Do not assume a histogram proves a cause, a forecast, or a particular statistical distribution. Its appearance depends on the observations included and the bin choices. A small sample can look irregular even when the underlying process is stable, while a large dataset can make small differences appear visually prominent. Check the source data, sample size, time period, and bin width before drawing conclusions.

One common misconception is that histogram bars represent separate named categories. Unlike a standard column chart, neighboring histogram bars represent adjoining numeric intervals. Another is that the tallest bar is necessarily the average. It is the most populated interval, or modal bin, but it does not by itself give the exact mean or median.

Common problems and practical fixes

The chart includes a heading as a value: Check the range and label settings in Setup. Keep a descriptive header, but ensure Sheets recognizes it as a label.
Some observations are missing: Confirm the chart’s data range includes all relevant rows and that values are stored as numbers, not text. Text such as a number followed by an unexpected unit may not be treated as a numeric observation.
The bars look too coarse or too noisy: Change Bucket size under Customize > Histogram, then assess whether the resulting intervals are meaningful for the data.
The chart changes after editing the source: This is expected when its source cells change. If new rows are not included, update the range in Setup.
The histogram seems to hide outliers: Inspect the raw values and the horizontal scale. A distant value can stretch the axis and compress the main cluster; do not remove it without a documented reason.

For collaborative work, leave the source data intact and put any cleaned or filtered analysis in a separate range or sheet. That makes it easier to understand which observations fed the chart and to revisit choices such as excluding blanks or correcting entry errors.

Frequently Asked Questions

Does Google Sheets have a distribution chart?
Yes. Sheets includes a Histogram chart type, which is the standard choice for showing how numerical values are distributed across ranges. It does not provide a dedicated box-and-whisker chart type in the regular chart list.

How do I change the bin size in Google Sheets?
Select the chart, open the Chart editor’s Customize tab, and expand Histogram. Set Bucket size to a useful interval for your data. If that option is not visible, confirm that the selected chart type is Histogram.

Can I make a histogram from text categories?
Not meaningfully in the usual sense. A histogram groups numeric measurements into intervals. For categories such as departments or product names, make a count table and use a bar or column chart instead.

Why does my histogram show an extra frequency?
A manually calculated FREQUENCY table returns one count beyond the number of upper limits; that last count represents values greater than the final limit. Make sure the limits cover the range you intend to summarize.

Can I make a box plot in Google Sheets?
There is no dedicated box-and-whisker chart in the standard Sheets chart types. You can calculate summary statistics and construct a workaround, but it takes more setup and is less direct than using a histogram or another supported chart type.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.