Excel Double Column Chart: Create, Compare, and Format Data

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, a “double column chart” usually means a clustered column chart that places two data series side by side for each category. Arrange the category labels in the first column and the two series in the next columns, select the full table, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column.

What a double column chart means in Excel

Excel does not list “double column chart” as a formal chart type. People commonly use the phrase for a clustered column chart with two series: for each category, Excel draws a pair of vertical bars next to one another. The chart makes it easy to compare the two values within each category, as well as to compare a series across categories.

For example, a sales report might compare revenue in 2025 and 2026 across four regions. Each region appears along the horizontal axis, and its two bars represent the two years. A column chart is usually most useful when the categories are discrete and reasonably few in number. If the categories are dates across a long period, a line chart may show the trend more clearly.

“Double” describes the two series shown in the example, not a hard limit built into the chart type. A clustered column chart can display more than two series, but adding many bars to each category can make comparisons crowded. For a clear two-series comparison, give each series a meaningful name and keep the category labels concise.

Prepare the data before inserting the chart

Use a simple rectangular table with one header row. For example, enter this layout in cells A1:C5:

  • A1: Region; B1: 2025; C1: 2026
  • A2:A5: North, South, East, and West
  • B2:C5: the corresponding revenue values for each year

Put categories in the first column and series names in the top row. Select the headers and values together, such as A1:C5, before inserting the chart. Excel uses the headers to name the legend entries and the first column to label the category axis. Without headers, it may create generic series names such as Series 1 and Series 2.

Keep values in each series on a comparable scale and use consistent units. Do not put a text label or subtotal in the middle of the values. If the table includes a total row, either leave it out of the chart selection or understand that Excel will treat it as another category. A blank cell can also create a gap or an unexpected-looking bar, depending on the chart’s data settings.

Create a clustered column chart step by step

  1. Enter the data in a labeled table, with categories down the first column and two series across the next columns.
  2. Select the complete range, including the category labels and series headers.
  3. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column.
  4. Check that each category has a pair of bars and that the legend names match the series headers.
  5. Click the chart title and type a specific title, such as “Revenue by Region: 2025 and 2026.”

If the chart has the wrong grouping, select it and use Chart Design > Switch Row/Column. This changes whether Excel treats the rows or the columns in the selected range as series. For the example table, the intended result is four categories and two series; switching the orientation can instead produce two categories with four series. Use the option that supports the comparison the chart is meant to show.

On Excel for Mac, the chart gallery and contextual chart tabs are also available, though their placement can differ with the ribbon layout. Select the data, open the Insert tab, and choose the clustered column option in the column chart gallery. The menu wording or visible gallery arrangement can vary slightly by release.

Format the chart so comparisons are easy

Click the chart to reveal the contextual Chart Design and Format tabs. For axis labels, a legend, or data labels, use Chart Design > Add Chart Element and choose the relevant element. The chart’s plus button may also provide quick access to chart elements in the Windows desktop app.

Useful finishing choices include:

  • Use a descriptive title: Name the measure, categories, and comparison period when that information is not obvious from the surrounding report.
  • Keep series colors consistent: Use one color per series throughout a report so readers can recognize the same year or group in other charts.
  • Label selectively: Data labels can make exact values easier to read, but labels on every bar can clutter a chart with many categories. Add them when the numbers matter more than a quick visual pattern.
  • Check the vertical axis: For ordinary column charts, a zero baseline is generally important because bar lengths encode magnitude. A truncated scale can exaggerate differences.
  • Reduce decoration: Remove unnecessary borders or heavy gridlines if they compete with the data. Keep enough gridlines to help estimate values.

To edit the axis scale, right-click the vertical axis and choose Format Axis. The Format Axis pane lets you adjust bounds and units. Automatic bounds are often suitable, but a deliberately chosen maximum can make charts easier to compare when several charts use the same measure. Avoid changing the minimum away from zero merely to make small differences look dramatic.

Clustered, stacked, and 100% stacked columns

A clustered column chart is usually the right choice when the question is “How does series A compare with series B in each category?” Its paired bars keep the two values visible separately. This is the typical interpretation of a double column chart.

A stacked column chart combines series into one column per category. It is useful when both the total and each series’ contribution to that total matter, but comparing the height of a segment that does not start at zero can be harder. A 100% stacked column chart scales each category to 100%, emphasizing proportion rather than absolute totals. It should not be used to compare the actual totals because those differences are removed by the normalization.

For instance, if two departments’ costs need a direct side-by-side comparison for each quarter, clustered columns are often clearer. If the goal is to show how each department contributes to the quarterly total, stacked columns may fit better. If the question is how each quarter’s cost mix changes as a percentage, 100% stacked columns may be more appropriate.

When a secondary axis or combo chart is appropriate

Two series can be difficult to compare if one is much larger than the other or if they use different units. A common example is revenue in dollars alongside customer counts. Putting unrelated units on one vertical axis makes the chart misleading, while a secondary axis can show a second scale—but it can also encourage readers to compare bar heights that do not represent the same unit.

If the series use different measures, consider a combo chart instead of forcing both into a double-column comparison. A common design uses columns for one measure and a line for the other, with the second series assigned to a secondary axis when necessary. Select the chart, then use Chart Design > Change Chart Type and choose Combo if that option is available for the selected data and Excel version. Set the series chart types and secondary-axis option in the dialog. Explain the units clearly with axis titles or a legend.

For two series measured in the same units but with very different magnitudes, first check whether the underlying values or units were entered correctly. A secondary axis may be justified in some cases, but it changes the visual scale and makes the bars less directly comparable. A separate chart or a table may be more honest and easier to interpret.

Fix common double column chart problems

  • Only one bar appears per category: Confirm that both value columns are in the selected range and that their headers are included. Use Chart Design > Select Data to inspect the plotted series.
  • Categories and series are reversed: Try Chart Design > Switch Row/Column. Check the legend and horizontal axis afterward rather than assuming the reversal fixed the intended layout.
  • The legend says Series 1 or Series 2: Add clear headers to the source columns, or edit the series names in Chart Design > Select Data.
  • A bar is missing or a gap appears: Check the source cell for blanks, text stored instead of a number, or a formula returning an empty string. Review Chart Design > Select Data > Hidden and Empty Cells to see how Excel treats empty cells.
  • The chart includes unwanted totals: Adjust the selected data range or edit the chart’s data source so subtotal and grand-total rows are not plotted as ordinary categories.
  • Labels are unreadable: Widen the chart, shorten category labels, reduce the number of categories, or switch to a bar chart when long text labels need more room.

If the source data is an Excel table, adding rows to the table can help the chart’s source range expand as the table grows. Still, check the chart after expanding or reorganizing the table: a new column may become another series, and a totals row can be included unintentionally.

Alternatives when two bars are not the clearest choice

A clustered bar chart uses horizontal bars instead of vertical columns. It can be easier to read when category names are long, and it is often a practical alternative for rankings. A line chart can better communicate change over a continuous time axis, particularly with many dates. A table with conditional formatting may be preferable when readers need exact values and there are too many categories for a chart to stay legible.

Do not choose a double column chart solely because there are two data columns. Choose it when the central task is comparing two measures or groups for each category and the values can sensibly share an axis. If the audience needs to see composition, a stacked chart may answer the question better; if it needs to see a trend, a line chart may be a clearer fit.

Frequently Asked Questions

How do I make a double column chart in Excel?
Select a labeled data range containing category names and two value series. Choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel displays the two series side by side for each category.

Is a double column chart the same as a clustered column chart?
Usually, yes: “double column chart” is an informal description for a clustered column chart showing two series per category. Clustered column is the chart type name used in Excel; it can also display more than two series.

How do I change the chart from rows to columns?
Select the chart and choose Chart Design > Switch Row/Column. This changes how Excel interprets the selected data. Verify that the category axis and legend now match the comparison you want.

Can I add data labels to both columns?
Yes. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a label position. If the chart is crowded, label only the values readers need to identify precisely.

Should a column chart start at zero?
For a standard column chart, a zero baseline helps preserve the visual meaning of bar lengths. Changing the axis minimum can make small differences appear much larger, so use a nonzero minimum only when there is a clear reason and the scale is plainly communicated.

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.