Cluster Column Chart in Excel: Create and Format It

Charts & pivot tables · Updated November 19, 2026

To make a clustered column chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each data series in its own column, select the range, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel creates side-by-side vertical columns so you can compare series across categories.

What a clustered column chart shows

A clustered column chart uses vertical bars, called columns, to compare values across discrete categories. Within each category, Excel places one column for each series next to the others. For example, a shop could compare sales for three product lines across four quarters: each quarter is a category, and each product line is a series. The columns make it possible to compare product lines within a quarter and to follow one product line across quarters.

The chart normally includes a horizontal category axis, a vertical value axis, and a legend that identifies the series by color. Column height represents the plotted value, so the scale on the value axis affects how large differences appear. A clustered column chart is most useful when the categories have a natural order or when side-by-side comparisons matter. It is less useful when many series or categories crowd the chart, or when the goal is to show how each category total is divided into parts.

Prepare the worksheet data

Give the chart a rectangular data range with clear headings. Put category names down the first column and series names across the top row. Each value should sit at the intersection of its category and series. For instance, a small table might have Quarter in A1, North in B1, and South in C1, followed by Q1 through Q4 in A2:A5 and the corresponding regional values in columns B and C. Select the headings along with the values so Excel can use them for axis labels and the legend.

  • Use one row per category and one column per series, without blank rows or columns inside the table.
  • Use consistent units and periods. Mixing dollars and percentages in the same ordinary chart can make comparisons misleading.
  • Keep category labels concise; long labels can be hard to read beneath vertical columns.
  • Include a meaningful title in the worksheet headings. Excel usually uses those headings as series names, which is clearer than generic names such as Series 1.

If the first row and first column are not recognized as headings, Excel may plot them as data or create unhelpful legend entries. Correcting the table before charting is usually easier than repairing several mistaken labels afterward. For a table formatted as an Excel table, selecting a cell and inserting a chart can also make it easier to extend the source data later; check the chart after adding rows to confirm the new data is included.

Create the chart in Excel

  1. Select the complete data range, including its row and column headings.
  2. Open the Insert tab on the ribbon.
  3. In the Charts group, choose Insert Column or Bar Chart.
  4. Under 2-D Column, select Clustered Column. Avoid 3-D effects for ordinary comparisons because perspective can make column sizes harder to judge.
  5. Move or resize the chart as needed. Drag its border to move it, or use a corner sizing handle to change its dimensions.

Excel may show chart suggestions in the Recommended Charts window, but choosing the specific Clustered Column option gives you direct control over the chart type. If the chart appears with the series and categories reversed, select it and choose Chart Design > Switch Row/Column. This changes which data groups become series and which become categories; it does not change the underlying worksheet values.

On Excel for Mac, the chart type is also available from the Insert tab through the column or bar chart controls, although ribbon layout and labels can vary by release. Excel for the web offers chart insertion too, but some detailed formatting controls may be arranged differently or be less extensive than in the desktop app.

Choose the right categories and series

The chart works best when the reader can compare a manageable number of series within each category. Three or four series are often easier to scan than a dozen, though the right number depends on the chart size and label length. Each additional series adds another color and another column to every cluster. If the chart becomes dense, consider showing fewer series, splitting the information into separate charts, or using a different chart type.

Think about what the audience needs to compare. If the question is whether North or South had higher sales in each quarter, clustered columns are a natural fit. If the question is how each region contributes to a quarterly total, a stacked column chart may communicate the composition more directly. A 100% stacked column chart shows relative shares rather than the original totals, so it is not interchangeable with a standard clustered chart.

Categories should also be comparable. Months, regions, products, and departments are common categories, but an unordered collection of long descriptions can be difficult to interpret. Sort categories deliberately when order matters, such as arranging months chronologically or products by a stated measure. Excel generally follows the order of the source data, so changing the worksheet order can change the chart order.

Format titles, axes, labels, and colors

A chart should explain its measure and scope without forcing readers to guess. Select the chart and use Chart Design > Add Chart Element to add or remove elements such as chart titles, axis titles, data labels, and gridlines. A useful title might say Quarterly Sales by Region rather than simply Sales. Axis titles can clarify units, such as Revenue (USD) or Units Sold. Avoid adding every available element: labels, gridlines, legends, and titles are helpful only when they improve understanding.

Data labels can make exact values easier to read, but labels on every column may overlap when a chart has many data points. Add them through Chart Design > Add Chart Element > Data Labels, then choose an appropriate position. If exact figures are not essential, a clearly scaled value axis may be less cluttered. For a small chart in a presentation, labels can help; for a dense monthly report, they may obscure the comparison.

To adjust the value scale, right-click the vertical axis and choose Format Axis. Excel lets you set bounds and units in the formatting pane. A value axis that starts above zero can exaggerate modest differences between columns, so use that choice cautiously and make the scale clear. For most column charts comparing magnitudes, a zero baseline is the straightforward choice. Format numbers consistently with the data, such as currency, whole numbers, or percentages.

Use colors consistently and make series distinguishable. Select a series to format it, or use Chart Design options to apply a chart style or change the color palette. Avoid relying only on subtle color differences if the chart may be printed in grayscale or viewed by people with color-vision differences. A clear legend and direct labels, where practical, can provide another way to identify each series. Keep decorative effects such as gradients, shadows, and 3-D styling restrained.

Edit the chart after insertion

When the chart is selected, Excel displays contextual chart tabs, including Chart Design and Format. To change the source range or check how Excel has interpreted the data, use Chart Design > Select Data. In the Select Data Source window, you can add, remove, or edit a series and adjust the category-axis labels. This is useful when a new period has been added to the worksheet but does not appear in the chart.

Use Chart Design > Switch Row/Column when Excel has grouped the data in the wrong direction. For example, a table with quarters in rows and regions in columns normally makes quarters the categories and regions the series. Switching the orientation makes the regions the categories instead. Choose the orientation that best matches the comparison the chart is intended to answer, and verify the legend and axis labels afterward.

To change the chart type, select the chart and choose Chart Design > Change Chart Type. This lets you move from a clustered column to a stacked column, bar, line, or another supported type without rebuilding the worksheet. When you change types, inspect the axes, labels, and colors: settings that worked for the original chart may not suit the new one.

Common problems and practical fixes

  • The categories and series are backwards: Use Chart Design > Switch Row/Column, then check whether the legend now represents the intended groups.
  • The legend says Series 1 or shows the wrong names: Include the heading row or edit the series names through Chart Design > Select Data. Confirm that headings are text labels, not values meant to be plotted.
  • Some values are missing: Check whether the selected chart range includes those cells and whether the values are stored as numbers rather than text. Also look for hidden rows or columns and inspect the chart’s data selection settings.
  • Column labels are cramped: Widen the chart, shorten category names, reduce the number of categories, or consider a clustered bar chart, which uses horizontal bars and can accommodate longer category labels.
  • The chart looks crowded: Remove unnecessary data labels, reduce the number of series, or make separate charts for distinct comparisons. Shrinking all text until it fits usually makes the result harder to read.

A related misconception is that a taller column always means a large real-world difference. The visible difference depends on the axis scale, and the values may also be affected by inconsistent units or periods. Before sharing the chart, verify the source cells, the axis bounds, the legend, and the title. A chart is a visual summary, not a substitute for checking whether the comparison is fair.

Clustered column versus other chart types

Choose clustered columns when side-by-side comparisons across a small or moderate number of categories are the priority. Choose clustered bars when category names are long or a horizontal layout fits the page better. The underlying idea is similar, but the orientation changes: columns rise vertically, while bars extend horizontally.

Use stacked columns when the total and its component parts matter, because each category’s series are placed on top of one another. This makes the total visible but makes it harder to compare middle segments across categories. Use 100% stacked columns when the emphasis is on proportions that sum to 100%, not on differences in total size. A line chart is often more suitable for showing a trend over many sequential time periods, especially when the continuity of change matters more than comparing separate groups.

Frequently Asked Questions

What is a clustered column chart in Excel?
A clustered column chart places vertical columns for multiple data series next to one another in each category. It is designed for comparing values between series and across categories, such as regional sales by quarter.

How do I make a clustered column chart in Excel?
Arrange categories in the first column, series headings across the top row, and values in the table. Select the range, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column.

How do I switch rows and columns in an Excel chart?
Select the chart and choose Chart Design > Switch Row/Column. This changes how Excel assigns the source data to categories and series; check the resulting axis labels and legend to ensure the chart tells the intended story.

Can I add data labels to a clustered column chart?
Yes. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. If labels overlap, remove them or label only the values that readers need to identify precisely.

What is the difference between clustered and stacked columns?
Clustered columns place series side by side for direct comparison. Stacked columns place series segments on top of each other to show category totals and their composition. A 100% stacked chart shows each series as a share of its category total.

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.