How to Insert a Clustered Column Chart in Excel

Charts & pivot tables · Updated November 20, 2026

To insert a clustered column chart in Microsoft Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data series in its own adjacent column, select the data range including its headers, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel creates a chart with vertical columns grouped side by side, making it easy to compare values across categories.

Before you begin, check that your data has clear labels and that each row represents one category, such as a month or product. You can adjust the chart’s title, labels, colors, and data later, so the initial goal is to select a well-organized range and insert the right chart type.

What You’ll Need

  • A worksheet containing numeric values to compare.
  • A category label for each row, such as a month, region, or product name.
  • A column heading for each series, such as 2025 and 2026 or Actual and Target.
  • Microsoft Excel. These instructions use Excel for Microsoft 365 on Windows; the chart options are similar on Mac, though ribbon placement can vary slightly.

A simple layout might have Month in A1, Online in B1, and Store in C1, with the month names below the first heading and values in the other columns. The first row of headings helps Excel identify the separate series, while the first column supplies the categories shown along the horizontal axis.

Step-by-Step

  1. Arrange the source data. Put category labels in the first column and series names in the first row. Enter one category per row and one value per series for that category. For example, columns could contain Month, Online, and Store, with January, February, and March in the rows below. Keep the data in one continuous rectangular block; blank columns or unrelated notes inside the block can make Excel interpret the range incorrectly.
  2. Check the values and headings. Make sure the values you want to compare are numeric, not numbers stored as text. Use distinct, descriptive series headings because Excel uses them in the chart legend. Avoid merged cells in the selected range. If the worksheet has a title or notes above the table, do not include those rows unless they are genuinely part of the chart data.
  3. Select the data range. Click the first cell of the table, then drag to the last cell, including the heading row and category labels. If the table occupies A1:C4, select A1:C4. You can also click a cell inside a clean, contiguous data table; Excel often detects the surrounding range automatically, but selecting the exact range yourself is more reliable when the sheet contains nearby data.
  4. Insert the clustered column chart. On the ribbon, select Insert > Insert Column or Bar Chart. In the 2-D Column group, choose Clustered Column. Avoid choosing Stacked Column or 100% Stacked Column unless you specifically want the values combined visually rather than displayed as side-by-side comparisons. Excel inserts the chart on the current worksheet.
  5. Check how Excel assigned the series and categories. Each category should appear along the horizontal axis, and each series should have its own color in the legend. If the chart groups the data the wrong way—for example, it shows months in the legend instead of along the axis—select the chart, open Chart Design, and choose Switch Row/Column. Look at the result and keep the orientation that makes the comparisons clear.
  6. Give the chart a useful title. Select the title area on the chart and type a concise description, such as Monthly Sales by Channel. If a title is not visible, select the chart and use Chart Design > Add Chart Element > Chart Title, then choose a placement. A title should explain what the numbers represent; it should not merely repeat the series names already displayed in the legend.
  7. Add labels or axis titles when they help. To display the values on the columns, select the chart and choose Chart Design > Add Chart Element > Data Labels, then pick a position such as Outside End. To identify the axes, use Chart Design > Add Chart Element > Axis Titles and choose Primary Horizontal or Primary Vertical. Add only the information readers need; labeling every value and axis can make a small chart crowded.
  8. Adjust the chart’s appearance and position. With the chart selected, use Chart Design to choose a chart style or change colors, and use the Format tab for more detailed formatting. Drag a corner handle to resize the chart without changing its proportions. Drag the chart area to move it. If you prefer a separate chart sheet, use Chart Design > Move Chart and select New sheet.
  9. Confirm the chart reflects the intended data. Compare a few plotted columns with the worksheet values, check the legend against the headings, and make sure no category or series is missing. If you add rows or columns outside the original selection later, the chart may not include them automatically. Select the chart and use Chart Design > Select Data to inspect or revise the chart’s data range and series.

Common Mistakes

  • Selecting only the numbers: Without the category labels and series headings, Excel may create generic axis labels or names such as Series 1. Include the header row and label column whenever possible.
  • Choosing a stacked chart by mistake: A clustered chart places series side by side. A stacked chart places one series on top of another, which answers a different comparison question. Check the chart name in the Insert menu before clicking.
  • Including extra cells: Selecting a worksheet title, totals, blank rows, or unrelated data can create unwanted categories or series. Select only the table needed for the comparison.
  • Using inconsistent units: A chart can be misleading if one series is in dollars and another is in thousands of dollars, or if the categories do not refer to comparable periods. Standardize units or make differences explicit in headings and axis titles.
  • Overloading the chart: Too many categories or series make columns narrow and the legend hard to follow. A clustered column chart works best when the reader can distinguish the groups at a glance.

Tips

  • Use an Excel Table for data that grows. Select the data and choose Insert > Table, confirming that the table has headers. Charts based on a table are generally easier to extend when you add new rows, although check the chart range after changing the layout.
  • Keep series order meaningful. Excel plots series in the order shown in the source data. Put related series next to each other and arrange them in a sensible sequence, such as earlier year then later year.
  • Use consistent formatting. Choose distinct colors with enough contrast, and keep the same color for a series across related charts. If the chart may be printed in grayscale, do not rely on color alone to identify the series.
  • Make units clear. Use a vertical axis title or a concise chart title when readers might not know whether values are dollars, units, percentages, or hours. Format the source cells appropriately so Excel can display values in a readable way.
  • Think about the comparison. Clustered columns are especially useful for comparing a few series within each category. If the main point is change over a long time period, a line chart may communicate the trend more clearly; for a part-to-whole comparison, consider whether a stacked chart is more suitable.
  • Keep the chart connected to its source. Avoid copying plotted values into a separate, manually maintained range unless there is a reason to do so. A chart linked to its data updates when the source values change, reducing the chance of displaying stale numbers.

Troubleshooting

The chart is blank or some columns are missing. Check whether the selected cells contain numeric values. Values imported as text may not plot as expected. Also inspect the chart’s source range by selecting the chart and choosing Chart Design > Select Data. Confirm that it covers all intended rows and series. If the source data is filtered, check whether the chart is set to display data in hidden rows and columns through the Select Data dialog’s Hidden and Empty Cells option.

Categories appear in the legend, or series appear on the horizontal axis. Excel has likely interpreted rows and columns in the opposite direction from what you intended. Select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, use Select Data to check the series names and category axis labels and confirm that the source range is oriented as expected.

The axis shows dates or unexpected numbers. Excel may have recognized the category labels as dates, or it may have included a numeric identifier as a data series. Review the selected range and the category axis labels in Select Data. If the labels are meant to be text, check their cell format and the source values; a number format alone does not change the underlying value.

The chart looks crowded or labels overlap. Reduce the number of categories displayed, make the chart wider, or remove data labels that are not essential. You can also shorten long category names in the source data, provided the shorter labels remain clear. If there are many categories, a clustered bar chart may be easier to read because its category labels run vertically along the chart.

The chart does not update after adding data. Check whether the new rows or columns are inside the chart’s source range. Select the chart and choose Chart Design > Select Data to extend the range. If new records will be added regularly, consider converting the source range to an Excel Table and verify that new entries are included in the chart.

The ribbon options are missing. Click the chart once to display the contextual Chart Design and Format tabs. If you are using Excel for Mac, the same chart controls are available on the ribbon, but the layout and labels may differ slightly by release. In Excel for the web, select the chart to reveal its chart formatting options; some detailed controls can differ from the desktop version.

Frequently Asked Questions

What is a clustered column chart in Excel?
A clustered column chart uses vertical columns arranged side by side for each category. Each color represents a data series, so you can compare multiple values within categories such as months, products, or regions.

What is the difference between a clustered column chart and a bar chart?
Both can compare categories and series. A clustered column chart uses vertical columns, while a clustered bar chart uses horizontal bars. Horizontal bars often make long category labels easier to read.

Can I add another series after creating the chart?
Yes. Add the series to the source data, select the chart, and open Chart Design > Select Data. Update the chart data range or use Add in the dialog to include the series, then confirm its name and values.

How do I change the chart’s colors?
Select the chart and open Chart Design. Choose Change Colors to apply a coordinated palette, or select an individual series and use the formatting controls on the Format tab for a more specific color. Keep series colors distinct enough to tell apart.

Can I make a clustered column chart in Excel for Mac?
Yes. Select the data, open the Insert tab, and choose the column chart option for a clustered 2-D column chart. The ribbon arrangement can vary slightly from Windows. After insertion, select the chart to access its design and formatting controls.

Why does Excel show Series 1 instead of my heading?
The heading may have been left out of the selection, or Excel may not recognize it as the series name. Include the header row when selecting data, or choose Chart Design > Select Data and edit the series name to refer to the correct heading cell.

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.