In Excel: select the numeric data, choose Insert ▸ Statistic Chart ▸ Histogram, then adjust bin width or number of bins from the horizontal axis options.
Put the numeric values in one clean column without totals.
Select the values and choose Insert ▸ Statistic Chart ▸ Histogram.
Right-click the horizontal axis and tune bin width, number of bins, overflow or underflow bins.
Add a title that states the measured variable and period.
What this does
A histogram groups numeric values into bins and shows how many values fall into each bin. Unlike a bar chart, the x-axis represents continuous numeric intervals, so bin width controls the story. It is the right chart for distributions: order sizes, ages, scores, response times and measurement error. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “add histogram in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A2:A101 contains 100 delivery times in days. Select the values and insert a Histogram. If Excel picks bins of 0-2, 2-4 and 4-6 days, you can right-click the horizontal axis and set Bin width to 1 to see a clearer daily distribution. Histograms quickly reveal spread, skew, clusters and outliers, which makes them useful before averages, forecasts and process decisions. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Treat “add histogram in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.
Common mistakes
- Using text categories instead of numeric values.
- Leaving totals or summary rows inside the selected data.
- Accepting automatic bins when they hide important clusters or outliers.
- Comparing two groups in one histogram without consistent bins.
Frequently asked questions
What is a histogram used for?
It shows the distribution of numeric values by counting how many fall into each interval.
How do I change histogram bins?
Right-click the horizontal axis, open Axis Options and change bin width or number of bins.
Histogram or bar chart?
Use a histogram for numeric intervals; use a bar chart for separate categories.