Column Chart in Excel: How to Create and Format One

A column chart in Excel displays values as vertical bars, making it easy to compare categories or track changes across periods. To create one in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column.

What a column chart shows

A column chart uses the horizontal axis for categories and the vertical axis for numeric values. Each column represents a category or a series of values, and its height corresponds to the value on the vertical scale. For example, a chart of monthly sales can show one column for each month, so a reader can quickly spot the strongest and weakest periods.

Column charts are especially useful when the categories are discrete and relatively few. Common examples include sales by product, votes by candidate, expenses by department, or website visits by month. They make differences between categories visible without requiring someone to compare every number in a table.

Excel also offers bar charts, which use horizontal bars. The underlying comparison is similar, but the orientation changes: bar charts are often easier to read when category names are long or when there are many categories. “Column” describes the vertical orientation, not a specific data source or a special kind of worksheet column.

How to create a column chart

Arrange the worksheet so that labels and values sit in a clear table, then select the full range, including its headings. For example, put months in A1:A5 and sales figures in B1:B5, with a heading such as Month in A1 and Sales in B1. Select A1:B5 before inserting the chart. Excel can use the first row and first column as chart labels.

Select the data range, including the category labels and series headings.
Choose Insert > Insert Column or Bar Chart.
Under 2-D Column, choose Clustered Column for side-by-side comparisons.
Click the chart title to replace it with a useful description, such as Monthly Sales.

The chart appears on the worksheet as an object that can be moved or resized. Drag its border to reposition it, or drag a corner handle to change its size. If Excel assigns categories and series in the opposite direction from what you intended, select the chart and choose Chart Design > Switch Row/Column. This is common when a table has several rows of categories or when its orientation is not obvious to Excel.

To build a chart from a formatted Excel table, click within the table and insert the chart. If the table grows and the chart uses the table’s data, the chart can update as table rows are added. With a plain cell range, check the chart’s source range when you add data outside the range originally selected.

Set up the source data clearly

A straightforward layout makes Excel’s chart choices more reliable. Put one type of information in each column, use a header for each series, and put one category per row. Avoid blank rows or columns inside the data range, merged cells, and explanatory notes mixed into the values. For example, a table with Month, Store A, and Store B as column headings can show monthly results for two stores.

Keep the units consistent within a series. A column chart that combines dollars and percentages on the same value axis can be misleading because the scale cannot meaningfully represent both measures at once. If the measures need to appear together, consider separate charts or a carefully designed combination chart, and make the units and axes explicit.

Excel needs numeric values to draw columns to the correct heights. Numbers stored as text, error values, or cells containing labels such as “not available” may be omitted or handled unexpectedly. Check the source cells if a category is missing. Also check whether blank cells are intentional: chart handling of empty cells can be adjusted through Chart Design > Select Data > Hidden and Empty Cells.

Choose the right column chart type

Clustered Column is the usual starting point when the goal is to compare values across categories, including comparisons between multiple series. If the example has monthly sales for three regions, Excel places three columns beside one another for each month. This makes regional comparisons within a month direct, although a chart with many series can become crowded.

Stacked Column places series on top of one another. It shows both a category’s total height and how its component series contribute to that total. For example, stacked columns can show a department’s monthly spending split across expense types. Because only the bottom series shares a common baseline, comparing the heights of segments in the middle of the stacks is harder.

100% Stacked Column scales each category to the same total height. It is useful for comparing the percentage composition of categories, such as the share of survey responses by answer for each age group. It does not show the actual size of each group: a small group and a large group both reach 100 percent. Use labels or another chart if the absolute totals matter.

Excel also provides 3-D column options, but perspective can make heights and distances harder to judge. For ordinary comparisons, a 2-D chart is usually clearer. If the categories are ordered values such as dates, keep the order meaningful rather than sorting them arbitrarily.

Format the chart for readability

A chart should make the comparison clear before it adds decoration. Give it a title that identifies the measure and, when useful, the time period. Use Chart Design > Add Chart Element to add or remove elements such as axis titles, data labels, a legend, and gridlines. The exact options available depend on the selected chart type and Excel’s current selection.

Axis titles: Name the measure and units, such as Revenue (USD) or Units Sold.
Data labels: Show values directly on columns when readers need exact numbers; avoid labeling every bar if labels overlap.
Legend: Keep it when multiple series need identification. A single-series chart often does not need one.
Gridlines: Retain a few light horizontal gridlines if they help estimate values, but avoid visual clutter.
Colors: Use a restrained palette and apply consistent colors when the same series appears in related charts.

To change the value scale or number format, right-click the vertical axis and choose Format Axis. The Format Axis pane lets you adjust settings such as bounds, major units, and number display. A zero baseline is generally important for column charts because viewers judge values by column length; truncating the axis can exaggerate small differences. If a nonzero minimum is necessary for a specific reason, make the scale conspicuous and explain it.

On Excel for Mac and Excel for the web, chart controls may be arranged differently from the Windows ribbon, but the same basic tasks—choosing a chart type, adding labels, and formatting axes—are available. If you cannot find a particular control, select the chart or the chart element first; contextual chart tabs and formatting panes appear based on that selection.

Interpret comparisons responsibly

Column charts make visual comparisons quick, but the display depends on choices about categories, scales, and aggregation. A chart of daily sales across a full year may have too many columns to read; grouping values by week or month can show the broader pattern. Conversely, aggregation can conceal short-lived peaks, so retain the underlying detail when it matters.

Think about whether the values are totals, averages, counts, or rates. Comparing total customer complaints between two stores may be unfair if one store serves many more customers. A rate per customer may be more informative, provided the denominator is defined and the units are clear. Likewise, show missing data honestly rather than treating missing observations as zero, which implies a real measured value.

For a time series, use consistent intervals and chronological order. A column chart can emphasize discrete periods, while a line chart may communicate continuous movement more naturally, especially with many time points. The chart type should match the question: comparing categories, showing composition, or revealing a trend are related but not identical tasks.

Common column-chart problems

If the chart shows one column for each series instead of each category, Excel may have interpreted rows and columns in the wrong direction. Select the chart and try Chart Design > Switch Row/Column. If that does not resolve it, choose Chart Design > Select Data and inspect the chart data range, category labels, and series entries.

If a heading appears as a category or a number is missing, check that the selected range includes the intended cells and that values are stored as numbers. A heading in the first row is normally interpreted as a series name, but an irregular layout can confuse that interpretation. Correcting the source table is often more reliable than trying to repair a chart built from an unclear range.

If columns look too thin or crowded, reduce the number of categories shown, enlarge the chart, or switch to a horizontal bar chart for long labels. You can also adjust spacing by right-clicking a data series and choosing Format Data Series, then changing Gap Width. Be cautious: extremely narrow gaps can make categories appear to run together, while very wide gaps make comparisons feel disconnected.

If the chart does not include newly entered data, inspect the source range through Chart Design > Select Data. Add the missing cells or use an Excel table as the source so that new table rows can be included more conveniently. If a chart is blank, first check whether the source cells contain numeric values and whether the chart’s series refer to the intended worksheet.

Frequently Asked Questions

What is a column chart in Excel?
A column chart is a chart that represents data values with vertical rectangular bars. Categories appear along the horizontal axis, while bar height represents values on the vertical axis. Excel’s Clustered Column chart is a common choice for comparing categories.

How do I make a column chart in Excel?
Select the data, including its headings, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Add a descriptive title and check that Excel has assigned the category labels and series correctly.

What is the difference between a column chart and a bar chart?
A column chart uses vertical bars; a bar chart uses horizontal bars. Both can compare values across categories. Horizontal bars tend to suit long category names or many categories, while vertical columns commonly suit shorter labels and a modest number of comparisons.

How do I add values above columns?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement. The available positions can depend on the chart type. If labels overlap, show fewer labels or enlarge the chart rather than forcing every value into a crowded space.

When should I use a stacked column chart?
Use a stacked column chart when both category totals and the contributions of component series matter. Choose 100% Stacked Column when the main question is how proportions compare, and remember that this version hides differences in the categories’ absolute totals.

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.