Excel Bar Graph Grouping: Create Clustered Bars

To group bars in Excel, arrange each group as a separate data series, select the category labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel places the series for each category next to one another, making the chart useful for comparing groups such as product sales across months.

What grouping means in an Excel bar graph

In Excel, the chart type commonly meant by a grouped bar graph is a clustered bar chart. It displays horizontal bars in clusters: each category gets one bar for every series in the source data. For example, a chart comparing two products across four months has four category clusters, with two bars side by side in each cluster.

Excel uses “bar” for horizontal bars and “column” for vertical bars. The same side-by-side arrangement is available as a clustered column chart; choose that instead when vertical columns suit the labels or presentation better. The grouping describes how the series are arranged, not a feature that combines cells or data into a single value.

A grouped chart is especially useful when the reader should compare series within each category and compare the same series across categories. It is less suitable when the main point is each category’s total, or the proportion each series contributes to that total. Those comparisons call for a stacked or 100% stacked chart.

Arrange the source data for clear groups

Excel reads the rows and columns in the selected range to infer categories and series. A straightforward layout has one header row, one category column, and one column for each group to compare. For example:

Month	Product A	Product B
January	120	95
February	150	110
March	135	125

Selecting this table and inserting a clustered bar chart gives each month a cluster containing a Product A bar and a Product B bar. The legend uses the column headings, and the category axis uses the month names. Keep the labels and values together in one contiguous range where possible, and avoid blank rows or columns inside it; gaps can lead Excel to interpret the source incorrectly.

Use one row per category, such as a month, department, or region.
Use one column per group or series you want to compare.
Give every series a clear heading, and use consistent units for comparable values.
Keep totals separate from the component series unless you specifically intend to chart the total as another group.

If the data is arranged in the opposite orientation—for example, series in rows and categories in columns—Excel may still create a chart, but the clusters will represent a different comparison. You can change that orientation after insertion.

Create a clustered bar chart in Excel

These steps apply to Excel for Microsoft 365 on Windows. The ribbon labels are generally similar in Excel for Mac, though the exact layout can differ. Excel for the web also supports creating charts, but some formatting controls may be more limited than in the desktop app.

Select the range containing the category labels, series headings, and numeric values. Include the headings so Excel can name the series and legend entries.
On the ribbon, select Insert > Insert Column or Bar Chart.
Under 2-D Bar, select Clustered Bar. Choose Clustered Column instead if you want vertical bars.
Review the chart. Confirm that each category has the intended bars and that the legend names match the data headings.
Use the Chart Design and Format tabs, which appear when the chart is selected, to edit its data, layout, labels, and appearance.

For instance, selecting the sample table above produces three month clusters with two bars apiece. January shows 120 for Product A and 95 for Product B; February shows 150 and 110; March shows 135 and 125. The chart does not add the two values together: it presents them as separate bars for comparison.

Change which data is grouped together

If the chart shows one bar per month instead of one bar per product in each month, or the legend and category axis appear reversed, switch the data orientation. Select the chart and choose Chart Design > Switch Row/Column. Excel exchanges which source dimension supplies the categories and which supplies the series. Check the result rather than assuming the switch is correct: it depends on the shape of the selected range and how the data is laid out.

You can also use Chart Design > Select Data to review the chart’s source range and series. In that dialog, you can add or remove a series and edit its name and values, or change the category-axis label range. This is useful when a chart includes an unwanted totals column or leaves out a newly added data column. Make sure all series use compatible category labels; otherwise, bars can be missing or aligned with the wrong category.

For a chart that will be updated regularly, consider converting the source range into an Excel table with Insert > Table. A chart based on a table can generally include rows or columns added to that table, helping the chart stay connected to a growing dataset. Review the chart after changing the table, particularly if new series or categories have been added.

Group categories under broader headings

Grouping bars into series is different from grouping categories into levels. If you have a hierarchy such as year and quarter, put each level in its own label column and keep the series values in separate columns. For example, columns might be Year, Quarter, Revenue, and Expenses, with one row for each quarter. Select the label columns and values when creating the chart. Excel can display multi-level category labels along the category axis, so quarters can be read in the context of their year.

Multi-level labels do not make the bars themselves stacked or merged. The chart still plots one bar per series for each category row. If labels repeat, such as Q1 appearing under several years, including the year as a separate label level helps readers distinguish them. If the hierarchy is difficult to read, use a shorter label, create a separate combined label column, or split the data into clearer charts.

A common misunderstanding is that Excel’s worksheet grouping command creates grouped bars. Worksheet grouping is for selecting or organizing sheets, and grouping rows or columns hides or outlines worksheet data. Neither operation changes a chart to clustered bars; select the appropriate chart type instead.

Adjust spacing and readability

When bars appear too thin or too close together, select a bar and open Format Data Series. In the pane, adjust Gap Width to change the space between category clusters: a smaller gap makes bars look wider, while a larger gap adds more space. The precise percentage that looks best depends on the number of categories, series, and the size of the chart.

The Series Overlap setting controls how much bars from different series overlap within a category. For a conventional grouped chart, keep the series side by side rather than overlapping. If overlap is set too high, one bar can obscure another and the display no longer communicates the comparison clearly. These controls are available in the Format Data Series pane for supported chart types; pane labels or placement can vary slightly across Excel versions.

Other improvements can make a grouped graph easier to interpret:

Add a concise chart title that says what is being compared and, where useful, the time period.
Keep the legend labels short and meaningful; use the source headings to give series clear names.
Use data labels selectively when exact values matter, especially if the chart has only a few bars.
Use a consistent color for each series across related charts.
Check axis labels and number formats. Large numbers, currency, and percentages should be formatted in a way that matches the data.

For a horizontal bar chart, Excel places the category labels on the vertical axis and numeric values on the horizontal axis. If the categories appear in an unexpected top-to-bottom order, select the category axis, open Format Axis, and review the axis options. Reversing the category order can help in some layouts, but it may also move the value axis or legend, so verify the full chart after changing it.

Choose between clustered, stacked, and other charts

Clustered bars emphasize comparisons between series within each category. In the example, they make it easy to see which product had higher sales in a particular month. They also allow readers to compare Product A from month to month, although many categories can make that task visually busy.

Stacked bars put series segments together in one bar per category. They emphasize the total and show how each series contributes to it, but comparing the middle segments across categories is harder because they do not share a common baseline. A 100% stacked bar chart normalizes each category to 100%, so it highlights proportions rather than the original totals. Use it when composition is the question, not when absolute values are the priority.

A line chart may be a better choice for a long time series where the trend matters more than the size of each individual bar. A clustered column chart is the vertical counterpart of a clustered bar chart. There is no universal best option: choose the chart that makes the intended comparison easiest to see, and avoid adding many series simply because the source table contains them.

Common grouping problems and fixes

Only one series appears. Check whether the selected range included all value columns and their headings. Use Chart Design > Select Data to inspect the series list.
Categories and series are reversed. Select Chart Design > Switch Row/Column, then confirm that the category labels and legend now represent the intended dimensions.
A totals column creates an extra bar. Remove the total as a series in Select Data, or select only the component columns when creating the chart. Totals alongside their components can also confuse readers.
Some bars are missing. Check for blank cells, text stored in place of numbers, or inconsistent category rows. Verify that the selected series ranges cover the same intended records.
The chart is crowded. Reduce the number of categories shown, shorten labels, enlarge the chart, or consider a different chart type. Decreasing Gap Width makes bars wider but does not solve an excessive number of categories.
Negative values extend in the opposite direction. This is expected: a bar chart uses the zero line as the baseline, with negative values extending the other way. Keep the axis scale and zero position visible when negative values matter.

When a chart looks wrong, check the source range and series/category assignments before changing colors or spacing. Formatting cannot correct a chart that is plotting the wrong data orientation.

Frequently Asked Questions

How do I put two bars side by side in Excel?
Select a category column and two or more value columns with headings, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Each category will have one bar for each value series.

What is the difference between a clustered bar and a stacked bar chart?
A clustered bar chart puts series next to each other for direct comparison. A stacked bar chart places series segments end to end in one bar per category, emphasizing the total and its composition.

How do I group bars by year and quarter?
Put year and quarter in separate category-label columns, with each quarter on its own row, and put the measures in separate series columns. Include both label columns when selecting the chart data so Excel can use multi-level category labels.

Why does Excel show my series as categories?
The selected data may be oriented differently from what you intend. Select the chart and use Chart Design > Switch Row/Column, or review the series and category ranges in Chart Design > Select Data.

Can I make the bars wider or closer together?
Yes. Select a bar, open Format Data Series, and adjust Gap Width. A smaller gap makes bars wider; the Series Overlap option changes the spacing relationship between series within each category.

Can I group bars without rearranging my worksheet?
Often, yes. Excel can plot a contiguous range and let you switch rows and columns, and Select Data lets you edit series and category ranges. However, organizing the source with categories in rows and series in columns usually makes the chart easier to maintain.

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.