2-D Clustered Column Chart in Excel: How to Make One

Charts & pivot tables · Updated November 19, 2026

To make a 2-D clustered column chart 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 places a separate vertical column for each series in each category, making it easy to compare values side by side.

What a 2-D clustered column chart shows

A clustered column chart compares values across categories by drawing vertical columns next to one another. The categories appear along the horizontal axis, and the values are measured on the vertical axis. A series is a group of related values, such as a product line, region, or year. Each series gets its own color, and its columns are positioned beside the other series within each category.

For example, imagine a table with months in the first column and sales for Store A and Store B in the next two columns. The chart places two columns for January, two for February, and so on. Their heights make the difference between the stores visible without requiring readers to compare figures in separate tables.

The 2-D option is a flat chart, not a three-dimensional one. This matters because 3-D perspective can make columns appear larger or smaller depending on their position. A 2-D chart presents the values without that perspective effect, which is usually preferable when the goal is an accurate visual comparison.

Arrange the worksheet data

Excel builds the chart from a rectangular range of cells. A clear layout helps it identify category labels, series names, and values correctly. A common arrangement is one header row followed by one row per category:

  • Put category names in the first column, such as months, departments, or locations.
  • Put each series name in the first row, such as Store A and Store B.
  • Enter numeric values where each category row and series column intersect.
  • Keep the range contiguous where possible, with no blank row or column separating the labels from the data.

For example, the first row might contain Month, Store A, and Store B. The next rows might contain January with 42 and 38, followed by February with 47 and 44. Select the headers along with the values so Excel can use the names for the legend and the month labels for the horizontal axis.

If your data has categories across the top and series down the left, Excel may interpret the rows and columns differently than you intend. That is not a problem with the chart type itself. After inserting the chart, use Chart Design > Switch Row/Column to change how Excel groups the data. Check that the legend and category labels then match the story you want the chart to tell.

Create a 2-D clustered column chart

  1. Select the full data range, including the series headings and category labels. If the range is large, you can select a cell inside the data and let Excel detect the connected range, but confirm the selection before inserting the chart.
  2. On the ribbon, select Insert > Insert Column or Bar Chart.
  3. Under 2-D Column, choose Clustered Column. Avoid Stacked Column if you want to compare each series directly rather than show how values add to a total.
  4. Review the new chart. Check that every category is present, the series names appear in the legend, and the columns represent the intended groups.
  5. Move or resize the chart by selecting its border and dragging. To place it on its own sheet, use Chart Design > Move Chart and choose New sheet.

In Excel for Mac, select the data and use the Insert tab to find the column chart choices; the exact button layout can vary by Excel build. In Excel for the web, select the range and use the Insert tab’s chart options. The chart-type names are generally similar, although the ribbon may be simplified. When the chart is selected, Excel displays chart-specific tabs or controls for editing it.

Customize labels, axes, and appearance

After insertion, select the chart to see its chart tools. In Microsoft 365 for Windows, the Chart Design and Format tabs offer commands for changing the chart type, selecting data, applying a chart style, and adjusting individual elements. The plus button beside a selected chart can also provide quick access to elements such as titles, axis titles, data labels, and gridlines.

Give the chart a title that identifies the measure and, where useful, the time period. For example, Monthly Sales by Store is more informative than Chart Title. Axis titles can clarify units, such as dollars or units sold. Add data labels when readers need exact values, but avoid labeling every column if it makes a crowded chart harder to read.

Use the legend to identify series and choose colors that remain distinct. A chart does not need a different decorative effect for every series; consistent, high-contrast colors are easier to interpret. If the series names are already clear and there is only one series, the legend may be unnecessary. You can select it and remove it without deleting the data.

The vertical axis normally begins at zero for a column chart. Keeping a zero baseline helps the visual length of each column reflect its value. If you change the axis bounds, make the change deliberate and visible: a truncated scale can exaggerate small differences. To adjust bounds, right-click the vertical axis, choose Format Axis, and edit the bounds in Axis Options. Available settings depend on the data and chart.

Choose clustered, stacked, or another chart

A clustered column chart is most useful when the reader should compare individual series within each category. It works well with a modest number of categories and a few series. As categories or series multiply, the columns become narrow and the legend and labels can become difficult to scan.

  • Clustered Column: places series side by side. Use it to compare the values of each series for each category.
  • Stacked Column: places series on top of one another. Use it to show how components contribute to a category total, while recognizing that only the bottom series shares a common baseline for direct comparison.
  • 100% Stacked Column: scales each category to 100 percent. Use it to compare proportions rather than absolute totals.
  • Bar chart: uses horizontal bars. It can be easier to read when category names are long or there are many categories.
  • Line chart: is often a better fit when the emphasis is a continuous trend over time rather than side-by-side comparisons at each time point.

These chart types answer different questions. A stacked chart does not simply make a clustered chart more compact: stacking makes the combined total prominent and makes comparisons between upper segments less direct. Choose the type based on whether the important message is individual values, composition, or change over time.

Common problems and practical fixes

If Excel displays one column for each row instead of grouping the expected series, check the data orientation. Select the chart and use Chart Design > Switch Row/Column. Then verify that the horizontal axis lists the categories and the legend lists the series. If the result is still wrong, use Chart Design > Select Data to inspect the chart data range, series, and category labels.

If a series name appears as Series 1 or Series 2, the chart may not include the header cells, or the header cells may be blank. Use Select Data to edit the series name or expand the selected range to include the proper headings. Similarly, if the horizontal axis shows numbers instead of category names, inspect the category label range in the Select Data dialog.

Unexpected gaps can come from empty cells, text stored where numeric values were expected, or missing observations. Check the worksheet values and the chart’s hidden and empty cell settings if relevant. Do not replace missing values with zero unless zero is genuinely what the data means: a zero says something different from an unavailable observation.

When columns overlap or look too tightly packed, reduce the number of displayed series, enlarge the chart, or adjust the gap width. Right-click a column and choose Format Data Series to find series options such as Gap Width. A smaller gap width makes columns wider; a larger one makes them narrower. The best setting depends on the number of categories, series, and available chart space.

Long category labels may crowd together. Try a wider chart, shorten labels in the source data when appropriate, or use a bar chart if the categories are numerous. Also check that the vertical axis uses a sensible scale and that number formatting communicates units clearly. A chart can be technically correct yet misleading if its labels, scale, or missing-value treatment are unclear.

Keep the chart useful as data changes

A chart based on a normal worksheet range typically updates when values in that range change. If you add new rows below the original range and they do not appear, the chart’s source range may not have expanded. One practical option is to format the source data as an Excel table: select the data and choose Insert > Table, then confirm whether the table has headers. Charts based on table data can include newly added table rows as the table grows.

Before sharing the workbook, check the chart at the size at which it will be viewed or printed. Make sure the title, legend, labels, and axis values are legible, and that color is not the only way to distinguish important information. For accessibility, give the chart a useful title and consider adding alternative text through the chart’s context menu or its accessibility controls, where available. A brief sentence in the worksheet can also explain the main takeaway for readers who cannot easily interpret the visual.

Frequently Asked Questions

What is the difference between a 2-D and 3-D clustered column chart?
A 2-D chart draws flat columns without perspective. A 3-D chart adds depth and perspective, which can make values harder to compare accurately. Use 2-D when clear value comparison is the priority.

How do I switch rows and columns in a clustered column chart?
Select the chart, then choose Chart Design > Switch Row/Column in Excel for Microsoft 365 on Windows. Check the resulting axis labels and legend to confirm the categories and series are oriented as intended.

Can a clustered column chart show more than two series?
Yes. It can display multiple series, but every added series creates another column in each category group. With many series, the columns can become narrow and the chart harder to read, so consider reducing the series or choosing another chart type.

Why are my category names appearing in the legend?
Excel may have interpreted rows as series and columns as categories, or the selected range may not include headers as expected. Try Switch Row/Column, then use Select Data to inspect the series and category label ranges.

How do I add values above the columns?
Select the chart and add Data Labels from the chart elements controls, or use Chart Design > Add Chart Element > Data Labels. Choose a label position that does not crowd the columns; for a dense chart, showing every value may reduce readability.

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.