Excel Histogram with Multiple Series: Methods That Work

Charts & pivot tables · Updated November 19, 2026

Excel’s built-in Histogram chart is designed for one data series at a time, so selecting several columns will not create a reliable overlaid histogram. To compare groups, first count each group using the same bin boundaries, then chart those counts as a clustered or overlaid column chart.

Why Excel’s Histogram Chart Uses One Series

A histogram groups a numeric data series into ranges, called bins, and displays how many observations fall in each range. In Excel for Microsoft 365 on Windows, the built-in chart is available through Insert > Insert Statistic Chart > Histogram. It is convenient for a quick look at one column of numeric measurements, such as the delivery times for one group of orders.

The chart’s bins are calculated from that selected series. When you want to compare two groups, however, each group needs to use exactly the same bin boundaries. If each series is binned independently, the bars may represent different ranges, making direct comparison misleading. Excel’s built-in Histogram chart does not provide the same multi-series controls as a regular column chart, so a shared frequency table is the dependable route.

This does not mean Excel cannot show several distributions. It means you prepare their frequencies first and use a standard chart to display them. That approach also gives you more control over bin widths, labels, percentages, and the appearance of overlapping bars.

Choose the Comparison You Need

Before building the chart, decide what the comparison should communicate. Two groups with different sample sizes can look quite different when plotted as raw counts, even if their underlying distributions are similar. Conversely, percentages can reveal the shape of each distribution without letting the larger group dominate.

  • Compare totals: Use counts when the number of observations in each bin is itself important and sample sizes are comparable.
  • Compare distribution shape: Use each bin’s share of its group, such as 25% of observations, when group sizes differ.
  • Compare probability density: Divide the bin’s share by its width when bins have unequal widths. This makes bar area, rather than just bar height, correspond to probability.
  • Show cumulative progress: Use a cumulative distribution chart if the question is what proportion falls below a threshold. A conventional histogram is not always the clearest choice for that task.

For example, suppose Group A has 100 measurements and Group B has 50. A count of 20 in a bin represents 20% of Group A but 40% of Group B. A count chart shows both values as bars of equal height; a percentage chart makes the difference in relative frequency visible.

Prepare the Data and Shared Bins

Put each group’s numeric observations in a separate column, with a descriptive header in row 1. For example, place Group A in A2:A101 and Group B in B2:B51. Keep text labels and blank cells out of the measurement ranges where possible. Decide how to handle blanks, errors, and any values that should be excluded before counting.

Create a small table with one row per bin. Put the lower edge in D and the upper edge in E. For bins from 0 to 40 in steps of 10, the rows could be 0–10, 10–20, 20–30, and 30–40. Use a consistent boundary rule: the example formula below counts values greater than or equal to the lower edge and strictly less than the upper edge. Thus, a value of 10 belongs to the 10–20 bin, not the 0–10 bin.

Make the first lower edge no greater than the smallest value, and make the final upper edge greater than the largest value, so the bins cover all observations. If you want to show values outside a selected range, add underflow and overflow categories rather than silently leaving those observations out. Equal-width bins are usually easiest to interpret and make the bar heights more directly comparable.

Count Each Series with the Same Bins

Put headers such as Group A and Group B in F1 and G1. In F2, enter the following formula, then fill it down for all bin rows and across for the other group. The row references for the edges change as you fill down, while the observation range for each group remains fixed.

With Group A’s values in A2:A101 and a bin’s lower and upper edges in D2 and E2, use:

=COUNTIFS($A$2:$A$101,">="&$D2,$A$2:$A$101,"<"&$E2)

For Group B in B2:B51, use the equivalent formula with that group’s range:

=COUNTIFS($B$2:$B$51,">="&$D2,$B$2:$B$51,"<"&$E2)

For bins 0–10, 10–20, 20–30, and 30–40, suppose the counts are 10, 25, 40, and 25 for Group A, and 20, 15, 10, and 5 for Group B. Those counts total 100 and 50, respectively. The table is now the key to a fair chart: every series uses the same bin limits and the same boundary rule.

Check that each group’s bin counts add up to the number of valid observations included in the analysis. If they do not, look for values below the first edge, values at or above the final edge, blanks, text stored as numbers, or errors in the source data. This reconciliation is an important safeguard against a chart that appears plausible but omits data.

Build a Multi-Series Histogram-Style Chart

Select the bin labels and the frequency columns, including their headers. If the lower and upper edge columns are not already represented by a clear label, create a label such as 0–10 or 10–20 in another column and use that for the chart’s horizontal axis. With the table selected, choose Insert > Insert Column or Bar Chart > Clustered Column.

A clustered column chart places the groups side by side within each bin. It is useful when readers need to compare the actual counts or percentages for each interval. To make it look more like a histogram, select a data series, open Format Data Series, and reduce Gap Width. A smaller gap makes the bins appear continuous; it does not change the calculated frequencies.

To place bars on top of one another, use Series Overlap in the Format Data Series pane and set it to 100%. Give the series distinct fills and apply transparency so the bar behind remains visible. Because overlapping bars can hide one another, change the series order if necessary and include a clear legend. If precise comparison matters more than a traditional histogram appearance, clustered columns are often easier to read.

Use a meaningful chart title and label the horizontal axis with the bin ranges. Label the vertical axis “Count” or “Percent,” as appropriate. Avoid calling a chart a percentage histogram if its bars still show raw counts; the axis and the values in the source table should agree.

Use Percentages When Group Sizes Differ

When comparing distribution shapes, calculate each bin’s share of its group. With Group A’s observations in A2:A101 and its first bin count in F2, enter this in H2 and fill down:

=F2/COUNT($A$2:$A$101)

The result for a bin containing 25 of the 100 observations is 0.25, or 25% when the cell is formatted as a percentage. For Group B, divide its bin count by the number of numeric observations in B2:B51. Use these percentage columns as the chart series. In the example above, Group A’s four bin shares are 10%, 25%, 40%, and 25%; Group B’s are 40%, 30%, 20%, and 10%.

Percentages make the groups comparable even though one has twice as many observations. They answer “What fraction of this group falls in the bin?” rather than “How many observations fall in the bin?” If you instead need a density histogram with unequal bin widths, divide each bin’s share by its width; otherwise wider bins can appear taller simply because they cover more values.

For a straightforward comparison, use the same bin widths across all groups. If different widths are necessary, explain the density calculation and label the vertical axis accordingly. Raw counts from unequal-width bins are especially easy to misread because a wider interval tends to collect more observations.

Built-In Histogram, ToolPak, or Frequency Table?

Use the built-in Histogram chart when you need a fast view of one numeric column and Excel’s automatic bins are suitable. Select the data and choose Insert > Insert Statistic Chart > Histogram. You can adjust bin settings by formatting the horizontal axis. This is the shortest workflow, but it does not solve the shared-bin, multiple-series comparison problem.

The Analysis ToolPak can create a frequency table for one input range at a time. If Data Analysis is not visible on the Data tab in Windows, enable the add-in through File > Options > Add-ins, choose Excel Add-ins in the Manage box, select Go, and check Analysis ToolPak. Then use Data > Data Analysis > Histogram and specify an input range and bin range. Repeat the operation for each group using the same bin range, or build the counts with formulas so the results update with the data.

The ToolPak is useful for a one-time frequency table, but it is less convenient when data changes often or when you want a linked chart with multiple groups. A COUNTIFS table is transparent and easy to audit; a PivotTable can be useful when the data is organized in a long format with a group column, but numeric values still need to be assigned to bins. Choose the method that best fits how often the data changes and how much control you need over the output.

On Excel for Mac, the ribbon and add-in availability can differ by release. The regular chart and worksheet formula approach is the most portable option. Excel for the web can display and edit many charts and formulas, but the exact availability of statistical chart and add-in controls may vary; use a desktop version when a required control is missing.

Common Problems and How to Fix Them

  • Bars do not line up across groups: Check that all series use the same lower and upper edges, in the same order. Independently generated bins are not a fair basis for side-by-side comparison.
  • The final bin seems to miss the maximum: The example formula excludes the upper edge. Set the final upper edge above the maximum, or deliberately add a final category that includes it.
  • Counts do not add to the sample size: Check for values outside the edge range, nonnumeric entries, blanks, and errors. Confirm that the ranges in the formulas cover all intended rows.
  • One group overwhelms the other: If sample sizes differ, switch from counts to within-group percentages when comparing shape.
  • Overlapping bars hide a series: Use transparency, adjust series order, or choose clustered columns instead. Do not sacrifice readability just to make the chart resemble a textbook histogram.
  • The chart axis shows categories in the wrong order: Review the order of the bin-label rows and the chart’s category-axis settings. Keep the source table sorted from the lowest interval to the highest.

A related misconception is that changing Gap Width turns any column chart into a statistically correct histogram. Gap Width affects appearance only. The correctness comes from numeric observations being counted into well-defined, consistent intervals, with an appropriate vertical measure.

Frequently Asked Questions

Can an Excel Histogram chart have two data series?
Not as a standard multi-series overlay in the built-in Histogram chart. Create a shared-bin frequency table for each group and chart the resulting columns instead.

How do I overlay two histograms in Excel?
Count both groups against identical bins, insert a Clustered Column chart, set Series Overlap to 100%, and use transparent fills. If the bars are difficult to distinguish, keep the series clustered side by side.

Should I use counts or percentages?
Use counts when group sizes are similar or absolute totals matter. Use within-group percentages when sample sizes differ and the goal is to compare distribution shapes.

Do I need equal-width bins?
Equal-width bins are easiest to compare. With unequal widths, use density rather than raw counts if bar height is intended to represent concentration, and explain the axis units.

Can I use different bin boundaries for each group?
You can, but the chart will not support a direct bin-by-bin comparison. Use common boundaries whenever the purpose is to compare distributions.

Which Method to Use

For one series, the built-in Histogram chart is the quickest choice. For several series, a shared frequency table and a regular column chart provide the control Excel’s histogram chart lacks. Use clustered bars for clarity, overlapping transparent bars when visual overlay is important, and percentages when sample sizes differ. The essential rule is simple: define the bins once and apply them consistently to every group.

Related

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.