In Excel for Microsoft 365 on Windows, select your category labels and series data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel calls this chart type a clustered column chart; it places each data series side by side within each category, making values easy to compare.
What a grouped column chart shows
A grouped column chart uses vertical columns to compare values across categories. Within each category, Excel places one column for every data series, using a different color for each series. For example, a store could compare sales for three product lines across four quarters. Each quarter forms a group, and the three product-line columns sit next to one another in that group.
The phrase grouped column chart is commonly used for this layout, while Excel’s chart-type label is Clustered Column. The columns are clustered together rather than stacked. This is useful when readers need to compare individual series within a category, or compare one series across categories. It works best when there are a manageable number of categories and series; too many columns can make the chart crowded.
A column chart is also distinct from a bar chart: columns run vertically, while bars run horizontally. Excel offers a corresponding Clustered Bar chart for the same side-by-side comparison when category names are long or there are many categories.
Arrange the worksheet data
Excel uses the table’s layout to determine which labels are categories and which values belong to each series. Put category labels in the first column, series names in the top row, and numeric values in the cells where each category and series meet. Keep the data in one continuous rectangular range, with no completely blank rows or columns splitting it.
For example, a simple quarterly sales table might look like this:
- Column A: Quarter, with Q1, Q2, Q3, and Q4 in rows 2 through 5.
- Row 1: Product A, Product B, and Product C in columns B through D.
- Cells B2:D5: the sales values for each product and quarter.
Include the header row and category-label column when selecting the range, such as A1:D5. Clear headings help Excel build a useful legend and axis labels automatically. Use consistent units throughout the values; mixing dollars and percentages in one ordinary column chart can create a misleading or unreadable scale. If the source is an Excel Table, clicking inside it and inserting a chart can make the chart expand as table rows are added, though it is still worth checking the chart’s selected data range.
Create the chart in Excel
- Select the complete data range, including its series headings and category labels.
- Open the Insert tab.
- Select Insert Column or Bar Chart, then choose 2-D Column > Clustered Column.
- Move or resize the chart as needed, then replace the default chart title with a descriptive one.
Excel inserts a chart with a horizontal category axis, a vertical value axis, and a legend for the series. If the chart appears to group the data in the wrong direction—for example, it shows one group per product instead of one per quarter—select the chart and choose Chart Design > Switch Row/Column. This changes which dimension Excel treats as the categories and which it treats as series; it does not rearrange or alter the source data.
On Mac, the chart options are also on the Insert tab, though the ribbon layout and menu appearance can differ from Windows. Select the data, use the column or bar chart control, and choose the clustered column option. The Chart Design tab appears when the chart is selected, as it does in Windows. Excel for the web has chart insertion and formatting tools too, but some advanced formatting controls may be more limited than in the desktop app.
Format labels, axes, and columns
A chart is easier to interpret when its title, units, and labels answer basic questions without requiring readers to inspect the worksheet. Select the chart and use Chart Design > Add Chart Element to add or edit a chart title, axis titles, data labels, gridlines, or a legend. You can also select a chart element and edit its text directly. A useful title says what is being compared and, when needed, the period or unit.
Use a vertical axis title such as Revenue (thousands of dollars) if the scale might otherwise be ambiguous. A legend should use short, recognizable series names. If the labels are already clear from the chart and there is only one series, a legend may be unnecessary. Data labels can show exact values, but adding labels to every column in a chart with many categories can create clutter. Consider labeling only when the precise values matter more than the overall pattern.
To change the vertical scale or number format, right-click the value axis and choose Format Axis. The Format Axis pane includes options such as bounds, units, and number formatting. Excel usually selects a scale automatically; adjust it only when there is a clear reason, and avoid a truncated baseline if it would exaggerate small differences between columns. For a conventional column chart comparing magnitudes, starting the value axis at zero generally makes the visual comparison fairer.
To change the spacing between columns, select a column, right-click, and choose Format Data Series. Under Series Options, adjust Gap Width. A smaller gap makes columns wider; a larger gap makes them narrower. This affects the appearance, not the underlying values. You can change series colors through the formatting controls, but use a consistent color for each series throughout the chart and choose colors that remain distinguishable when printed or viewed by people with color-vision differences.
Choose the right number of categories and series
Grouped columns are strongest when the reader can scan a few series across a modest number of categories. With many series, each category contains many narrow columns, and colors become difficult to distinguish. With many categories, the chart may become too wide or the category labels may overlap. There is no universal maximum: the useful number depends on the chart’s physical size, label length, and how precisely readers need to compare values.
If a chart is crowded, try a practical adjustment before adding more styling:
- Remove categories that are not relevant to the question, or show a shorter time period.
- Split unrelated series into separate charts rather than forcing them into one legend.
- Shorten category labels carefully, or use a clustered bar chart when long labels need more room.
- Use a line chart instead when the main point is a trend over many ordered time periods.
For instance, a chart comparing actual and forecast sales for four regions across six months may be readable with eight series only if the chart is large and the colors are clear. If the reader mainly needs to compare the monthly trend for each region, separate small charts or lines may communicate the pattern better.
Clustered, stacked, and 100% stacked columns
Clustered Column is appropriate when comparing the separate values of series within each category is important. Stacked Column places the series on top of one another, emphasizing the total for each category and each series’ contribution to that total. However, only the bottom series shares a common baseline, so comparing the size of upper segments across categories is harder.
100% Stacked Column scales each category to 100 percent. It is useful for comparing proportions when the categories have different totals, but it hides differences in the total amounts. For example, two departments could each appear to have a 50% share even if one department’s total is much larger. Use the chart type that matches the question: separate-value comparisons favor clustered columns, total-and-composition comparisons may favor stacked columns, and share comparisons favor 100% stacked columns.
A common misconception is that a grouped chart automatically calculates totals or percentages. It does not: it plots the values in the selected cells. Calculate any required totals or shares in the worksheet first, then chart those results.
Fix common chart problems
If Excel includes a heading as a data point or omits a category, inspect the chart’s source range. Select the chart and choose Chart Design > Select Data to review the data range, legend entries (series), and horizontal axis labels. You can edit a series or category-label range there. If the range was selected incorrectly, correcting it is usually better than rebuilding the chart.
If categories and series are reversed, use Chart Design > Switch Row/Column. If the legend displays generic names such as Series 1, check that the source range includes the intended header row or edit the series name in Select Data. If columns are missing, check for text stored in cells that should contain numbers, filtered or hidden data, and blank cells. Excel’s treatment of empty cells can be reviewed from the chart’s Select Data options through Hidden and Empty Cells.
When labels overlap, enlarge the chart, shorten labels, reduce the number of categories, or change to a clustered bar chart. If the chart does not update after worksheet edits, check that the edited cells are inside its source range. Charts based on a fixed range do not necessarily include data entered beyond the last selected row; an Excel Table can help keep the source range aligned with added records.
Make the chart accessible and useful
Color should not be the only way to distinguish series. Keep the legend visible, use clear series names, and make sure the text and columns have enough contrast against the background. Avoid decorative 3-D effects: perspective can distort the apparent size of columns and make comparisons less reliable. A simple 2-D chart is generally easier to read and reproduce.
Add alternative text when the chart will be shared in a document or presentation with people who use screen readers. In desktop Excel, right-click the chart and choose Edit Alt Text, then describe the main comparison and any important takeaway without merely repeating every plotted value. Also consider including a nearby data table when exact numbers are essential or when readers may need an accessible alternative to visual comparison.
Frequently Asked Questions
What is a grouped column chart called in Excel?
Excel calls it a Clustered Column chart. “Grouped column chart” describes the same side-by-side arrangement of series within each category.
How do I add another series?
Add a new series heading and its values to the source table, then use Chart Design > Select Data to update the chart’s data range or add the series. If the chart is based on an Excel Table, extending the table may update the chart automatically.
How do I switch the chart’s rows and columns?
Select the chart and choose Chart Design > Switch Row/Column. This changes the chart’s grouping orientation while leaving the worksheet values as they are.
Can I make a grouped column chart with percentages?
Yes. Put the percentage values in the source cells and format them as percentages. If the goal is to compare each category’s composition as shares totaling 100%, choose 100% Stacked Column instead of Clustered Column.
Why are my columns too narrow?
There may be many categories or series, or the chart may be small. Enlarge the chart, reduce the series or categories, or select a column and reduce Gap Width under Format Data Series > Series Options.
When should I use a clustered bar chart instead?
Use Clustered Bar when category labels are long, or when horizontal bars make the category comparisons easier to scan. It presents the same kind of side-by-side series comparison with the axes oriented differently.
Related
- Excel Won’t Group Dates in a PivotTable? Fixes That Work
- Excel Table Names: Where to Find, View, and Change Them
- Excel Weekly Meal Planner: Build a Reusable Template
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Trendline Tutorial: Add, Format, and Choose OneTo add a trendline in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design…
- Gantt Chart in Excel 2010: Formula and SetupIn Excel 2010, make a Gantt chart with a Conditional Formatting formula such as =AND(E$1>=$B2,E$1<=$D2). If column B…
- How to Import a Chart Template in Excel and Apply ItTo import a chart template in Excel for Microsoft 365 on Windows, copy its .crtx file into your…
- Excel Graph Reverse Data Order: Flip an Axis or SeriesTo reverse the order of categories in an Excel graph, select the chart, right-click its category axis, choose…
- Project Tracker Spreadsheet With Gantt Chart: How to BuildYes. In Microsoft Excel for Microsoft 365, a project tracker spreadsheet can show task names, owners, start and…
- Excel Chart Ignore Blank Cells? How to Control GapsYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.