Side-by-Side Column Chart in Excel: How to Make One

Charts & pivot tables · Updated November 20, 2026

To make a side-by-side column chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data series in its own column, select the full table, then choose Insert > Insert Column or Bar Chart > Clustered Column. A clustered column chart places the series for each category next to one another, making it easy to compare values across groups.

What a side-by-side column chart shows

Excel calls this chart type a Clustered Column chart. The columns extend vertically from a horizontal category axis, and separate series are grouped together at each category. For example, if a table lists quarterly sales for two regions, each quarter has one column for each region. The shared category position makes it straightforward to compare the regions within a quarter and to follow either region across quarters.

Despite the phrase side by side, you do not need to draw or position the columns yourself. Excel builds the groups from the series in your selected data. A chart with two series shows two columns per category; a chart with three shows three. The legend identifies the series, while the category axis identifies the groups.

This chart is most useful when the values use the same unit and are meant to be compared directly. It can show sales by region, expenses by department, survey responses by age group, or actual and planned output by month. It is less useful when there are many series or categories: the columns become narrow, labels crowd together, and the visual comparison gets harder.

Prepare the data in a clear layout

Put category labels in the leftmost column and series names across the top row. Keep each row as one category and each series in a separate numeric column. For a regional sales example, the table might have Quarter, North, and South as its headers, followed by Q1 through Q4 and the corresponding values. Include the headers in the selection so Excel can use them for the legend and category labels.

Before inserting the chart, check that the data is a consistent rectangular range. Avoid blank header cells, merged cells, explanatory notes inside the table, and totals that you do not want plotted. Use numbers rather than values stored as text; text-formatted numbers may not behave as expected. If your source data is an Excel table, selecting a cell in the table and inserting a chart can make the chart easier to maintain as the table grows.

A compact table is usually easier to read than a chart with a long list of categories. If category labels are dates, use a consistent date format. If the categories are months or quarters, make sure they are in the intended order rather than alphabetically sorted. A chart follows the order of the source data, so sort the table first if you need a different sequence.

Create the clustered column chart

  1. Select the complete range, including the header row and category labels. For example, select a table spanning A1:C5 if the headers are in row 1 and four categories occupy rows 2 through 5.
  2. On the ribbon, choose Insert > Insert Column or Bar Chart > Clustered Column. In the chart gallery, choose the basic two-dimensional Clustered Column option, not Stacked Column or 100% Stacked Column.
  3. Excel inserts the chart on the worksheet. Check that the category labels appear along the bottom and that the series names appear in the legend. If the grouping is the opposite of what you intended, select the chart and choose Chart Design > Switch Row/Column.
  4. Move or resize the chart using its border, then add a descriptive title. Select the title placeholder and type wording that identifies both the measure and the time period or population, such as Quarterly sales by region.

On a Mac, the chart type is also available from the Insert tab, although the ribbon layout and chart gallery presentation can differ. Excel for the web has chart insertion and basic formatting tools as well, but the location or availability of some detailed formatting controls can vary. The chart’s central requirement is the same: select the data and choose a clustered column chart.

Read and customize the chart

Keep the chart focused on the comparison rather than decorating it heavily. A clear title, readable category labels, a useful legend, and an appropriate vertical scale are often enough. If the series names are short and obvious, the legend can remain at the side or top; if space is tight, moving it below the plot area may help. Select the chart and use the chart elements controls or the Chart Design tab to add or adjust elements.

To show the values on the columns, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a placement such as Outside End. Labels can help when readers need exact figures, but they can clutter a chart with many bars. Consider adding labels only when there are relatively few columns or when precise values matter more than a clean visual pattern.

To adjust the gap between columns, right-click a column and choose Format Data Series. In the formatting pane, use Series Overlap and Gap Width. A Series Overlap of 0% keeps series side by side; increasing overlap makes the columns cover more of the same horizontal space and can make them appear to touch or overlap. Gap Width changes the spacing between category groups. Make small adjustments and check that individual series remain distinguishable.

Use consistent colors for the same series throughout a report. For example, if North is blue and South is orange in one chart, keep those assignments in related charts. Avoid relying only on color to convey a critical distinction when the chart may be printed in grayscale or viewed by someone with color-vision differences; clear legend names and data labels can provide additional cues.

Choose the right chart type

A clustered column chart emphasizes comparisons among series within each category. A stacked column chart instead combines the series into one column per category, showing both the total and each series’ contribution. Stacking makes it harder to compare the middle segments across categories because they do not share a common baseline. A 100% stacked column chart shows each category as a normalized whole, so it is useful for comparing proportions, but it hides differences in total size.

Use a bar chart when long category names need more room or when there are many categories; horizontal bars often keep labels readable. Use a line chart when the main point is a trend over an ordered, continuous time sequence, especially when the chart has many time points. A clustered column chart can still work for a few months or quarters, but a large number of narrow columns can make a time trend difficult to see.

A common misconception is that a clustered chart is automatically the best choice for comparing any two numbers. If the series have radically different scales, a small series may look almost flat beside a large one. Do not solve that problem by casually placing one series on a secondary axis: two axes can make apparent differences misleading. Consider separate charts, a clearly explained alternative scale, or a different measure that supports a fair comparison.

Fix common chart problems

  • Excel plots the series in the wrong direction: Select the chart and choose Chart Design > Switch Row/Column. This changes whether rows or columns are treated as series; it does not rearrange the source table.
  • The legend says Series 1 or Series 2: Check that the top row contains the intended series names and that the header cells were included in the selection. You can also select Chart Design > Select Data to review the series and category ranges.
  • Some categories or values are missing: Use Chart Design > Select Data to inspect the chart’s data range. Confirm that the missing rows or columns are included and that numeric values are not stored as text. For empty cells, the Select Data dialog includes options for how empty cells are displayed; a blank is not necessarily the same as a zero.
  • Columns are too thin or crowded: Reduce the number of categories or series, enlarge the chart, shorten labels, or adjust Gap Width in Format Data Series. If the chart still feels crowded, try a bar chart or split the comparison into two charts.
  • Small differences are hard to see: Check the vertical axis scale and the units. Column charts are generally easiest to interpret when the axis starts at zero, because column length represents magnitude. A truncated scale can exaggerate differences; if you change the axis bounds, make the change apparent and consider whether another chart type is more suitable.

Keep the chart useful as data changes

When you add new rows to an ordinary selected range, Excel may or may not include them automatically depending on how the range and chart were created. An Excel table is often a convenient source for data that will grow: add a row directly below the table and the table expands, and charts based on the table can update to include the new data. Check the chart after adding data, especially if you have inserted rows in unusual locations or changed the table structure.

For charts that will be reused, keep the source data in a predictable layout and avoid inserting decorative blank rows between records. Give every column a clear header, keep units consistent, and document any exclusions. If you copy a chart to another worksheet or workbook, verify that its series still point to the intended source. Use Chart Design > Select Data to inspect or adjust the range when the plotted values do not match the updated table.

Frequently Asked Questions

What is a side-by-side column chart called in Excel?
It is called a Clustered Column chart. Each category gets a group of columns, with one column for each data series.

How do I put two columns side by side for each category?
Arrange the category labels in one column and the two series in separate adjacent columns, select the data including its headers, then choose Insert > Insert Column or Bar Chart > Clustered Column.

How can I switch the chart so the categories and series are reversed?
Select the chart and choose Chart Design > Switch Row/Column. If the chart still does not look right, use Chart Design > Select Data to check the ranges and labels.

Can I make a clustered column chart with three or more series?
Yes. Add each series in its own column with a header, then select the full range and insert a Clustered Column chart. More series mean more columns in each group, so readability can decline quickly.

What is the difference between clustered and stacked columns?
Clustered columns place series next to each other so their values can be compared directly. Stacked columns place series segments on top of one another to show a combined total and its composition.

Why do my chart columns overlap?
Select a column, open Format Data Series, and check Series Overlap. Set it to 0% for side-by-side columns. If the chart has many series, also consider reducing the series count because spacing alone may not make it readable.

A quick final check

Before sharing the chart, confirm that its title describes the data, the legend matches the intended series, and all categories and values are included. Check that the vertical axis and units do not create a misleading impression, and view the chart at the size readers will actually see. A well-prepared table and a basic Clustered Column chart are usually enough to make group comparisons clear; formatting should support that comparison, not distract from it.

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.