A clustered column chart shows multiple data series next to each other so you can compare them at a glance

A clustered column chart is a bar graph where each category has multiple columns standing side by side. If you track monthly expenses across three departments, for example, you see all three departments' numbers for January grouped together, then all three for February, and so on. This layout makes it straightforward to spot which department spent the most in each month, or which month was most expensive across the board.

Excel builds these charts from a data table you already have. You select the numbers and labels, click the chart button, and pick the clustered column style. The whole process takes about two minutes once your data is organized the way Excel expects it.

Key Takeaways

  • Arrange your data in a table with categories in the first column and each data series in its own column to the right.
  • Select the entire table including headers, then go to the Insert tab and choose Clustered Column from the Charts group.
  • Excel automatically reads your layout and assigns colors to each series, with the category labels appearing along the bottom axis.
  • You can edit the chart title, axis labels, and legend after creation by double-clicking the chart and using the Design and Format tabs.

Set up your data in the right table format

Excel reads data in a specific way. Put your category labels in the first column — these become the labels along the bottom of the chart. Put each data series in its own column to the right, with a header row at the top that names each series.

For example, if you are tracking sales by region across three quarters, your table looks like this:

RegionQ1Q2Q3
North450005200058000
South380004100044000
East520005500061000
West410004800050000

The first column (Region) becomes the category axis at the bottom. The three columns to the right (Q1, Q2, Q3) become the three data series that will appear as different colored columns in each category group.

Select your data and insert the chart

Click on the cell in the top-left corner of your table and drag to the bottom-right cell to select the entire range, including headers and all numbers. You can also click the top-left cell, hold Shift, and click the bottom-right cell.

Go to the Insert tab at the top of the ribbon. In the Charts group, you will see a button labeled Column Chart or just Charts depending on your Excel version. Click it and a dropdown menu appears. Look for Clustered Column — it is usually the first option in the 2-D Column section. Click it, and Excel creates the chart and places it on your worksheet.

Understand what Excel created automatically

Excel reads your table and assigns each data series a different color. In the example above, Q1 appears in one color, Q2 in another, and Q3 in a third. Each region gets its own group of three columns along the bottom axis, labeled North, South, East, and West. A legend on the right side shows which color represents which quarter.

The chart title defaults to something generic like "Chart Title" or pulls from your data. The vertical axis shows the scale of your numbers. Everything is editable — you can change colors, labels, and the title without rebuilding the chart.

Edit the chart title and axis labels

Double-click the chart to enter edit mode. The chart border turns gray and the ribbon changes to show chart-specific tabs. Click on the title text to select it, then type a new title that describes what the chart shows — for example, "Regional Sales by Quarter".

To change the axis labels, right-click on the numbers along the left side (the vertical axis) or the category names along the bottom (the horizontal axis) and choose Format Axis. You can adjust the number format, the range of values shown, and the label text. For most charts, the defaults work fine and you only need to change the title.

Adjust colors and legend position

While the chart is in edit mode, right-click on one of the columns and choose Format Data Series. This opens a panel where you can change the color of that entire series — all the Q1 columns, for example, or all the Q2 columns. You can also adjust transparency and add borders to make the columns stand out.

To move the legend, right-click it and choose Format Legend. You can place it to the right, left, top, or bottom of the chart, or remove it entirely if your chart is straightforward enough that the colors are obvious. Click outside the chart when you are done editing to return to the normal worksheet view.

Common reasons your chart looks wrong

If your columns are stacked on top of each other instead of side by side, you selected a stacked column chart by mistake. Double-click the chart, go to the Design tab, click Change Chart Type, and select Clustered Column again.

If your numbers appear as categories along the bottom instead of as column heights, your data table is rotated. Excel read your columns as categories and your rows as series. Rearrange your table so categories are in the first column and data series are in columns to the right, then select and insert the chart again. If you have only two data points, the chart may look cramped — that is normal, and the chart still works correctly.

Frequently Asked Questions

Can I add more data series after I create the chart?

Yes. Add the new column to your original table, then double-click the chart and go to the Design tab. Click Select Data and add the new series to the list. Excel will automatically assign it a color and include it in all the category groups.

What is the difference between a clustered column chart and a stacked column chart?

In a clustered chart, columns stand side by side so you can compare values directly. In a stacked chart, columns sit on top of each other to show how parts add up to a total. Use clustered when you want to compare individual values; use stacked when you want to show composition.

How do I change the order of the data series in the chart?

Double-click the chart, go to the Design tab, and click Select Data. In the dialog box, highlight a series name and use the arrow buttons to move it up or down in the list. The chart updates when ready.

Can I print just the chart without the rest of the worksheet?

Click the chart once to select it, then go to File and choose Print. Excel detects that a chart is selected and prints only that chart at full page size. If you want the chart smaller or alongside other content, print the whole sheet normally.