To make a column chart in Excel, place category names in the first column and the values for each series in adjacent columns, select the complete range, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. For example, a table of products and quarterly sales becomes a chart with products along the horizontal axis and sales shown as vertical columns.
A simple column chart example
Suppose you want to compare units sold for four products in two quarters. Enter the data with one row per product and one column per quarter, including the headings:
| Product | Q1 | Q2 |
|---|---|---|
| Item A | 12 | 15 |
| Item B | 9 | 11 |
| Item C | 15 | 13 |
| Item D | 8 | 12 |
Select the cells containing the headings and values, then use the Insert tab and choose a clustered column chart. Excel uses the product names as categories, the Q1 and Q2 headings as series names, and the numbers as the column heights. The result places two columns beside each product, making it easy to compare the quarters. Item A rises from 12 to 15, for example, while Item C falls from 15 to 13.
Use a meaningful chart title such as Units Sold by Product and Quarter. If the values represent thousands of units or dollars, say so in the title or an axis title rather than leaving readers to guess. This small example is also useful for spotting a common layout rule: categories go down the rows, while comparable data series go across the columns.
What a column chart shows
A column chart represents values with vertical rectangular bars, usually called columns. The horizontal axis lists categories, such as products, months, or departments, and the vertical value axis uses a numeric scale. A taller column represents a larger value. When a category has multiple series, Excel can show one column for each series side by side or stack them together.
Column charts are especially useful when the categories are discrete and comparisons are the main point. They work well for a handful of months, product groups, or survey choices. They are less effective when the chart contains so many categories that labels and columns become crowded, or when the data is a continuous time series with frequent observations. In those cases, a line chart may communicate the overall trend more clearly.
Prepare the worksheet data
Good chart structure begins in the worksheet. Put a clear heading at the top of each column, use a single category per row, and keep the values in a consistent unit. Avoid merged cells, completely blank rows inside the data, and explanatory notes mixed into the numeric range. Excel uses the selected cells to infer the chart layout, so a tidy rectangular range makes that inference more reliable.
- One series: Put categories in column A and values in column B. A monthly revenue chart might have Month and Revenue as the headings.
- Several series: Keep the category labels in column A and add one headed value column for each group, as in the Q1 and Q2 example.
- Dates: Use actual Excel date values where possible, not dates typed as inconsistent text. This helps Excel treat the horizontal axis appropriately.
- Units: Do not mix unlike measures in one value series. For instance, combining dollars and percentages on the same axis can make the chart misleading.
Include the headings when selecting the range. They help Excel name the series and create a useful legend. If Excel assigns categories or series in the wrong direction, you can correct the interpretation after creating the chart rather than rebuilding the data.
Create the chart in Excel for Microsoft 365
In Excel for Microsoft 365 on Windows, the standard process is:
- Select the data range, including the category labels and column headings.
- Choose Insert > Insert Column or Bar Chart.
- Under 2-D Column, choose Clustered Column for a side-by-side comparison.
- Click the chart title and replace the placeholder with a descriptive title.
- Resize or move the chart as needed by dragging its border or corners.
The chart appears as an embedded object on the worksheet. When you select it, Excel displays contextual chart tabs, including Chart Design and Format. To add or edit a chart title or axis title, choose Chart Design > Add Chart Element and select the relevant element. To show values directly above the columns, choose Chart Design > Add Chart Element > Data Labels and select a position. The exact options shown can depend on the selected chart type.
Excel for Mac has a similar chart workflow through the Insert tab, although the wording and ribbon arrangement can differ between releases. Excel for the web also supports charts; select the range, use Insert > Chart, and adjust the chart type and options in the chart controls. Some detailed formatting choices may be easier to find in the desktop application.
Choose the right column chart type
Clustered Column is the clearest default when the question is how separate groups compare within each category. In the example, each product has a Q1 column and a Q2 column. This preserves the individual values and makes direct comparisons straightforward.
- Stacked Column: Places series on top of one another to show both a category total and the contribution of each series. It is useful when the parts add up to a meaningful whole, but comparing middle segments across categories is harder because they do not share a common baseline.
- 100% Stacked Column: Scales each category to 100 percent and emphasizes proportions rather than total size. It is not the right choice when readers need to compare the actual totals, since the columns all have the same overall height.
- 3-D Column: Adds perspective effects, but the depth can make values harder to judge and can obscure columns behind others. A 2-D chart is generally easier to read for ordinary comparisons.
Choose a chart type based on the question, not decoration. If you need to compare the total number of sales and the contribution from each sales channel, stacked columns may fit. If you need to compare every channel’s value across regions, clustered columns are usually more revealing.
Format the chart so it is easy to read
Formatting should clarify the data rather than compete with it. Use a specific title, keep the legend close to the chart, and choose colors that distinguish series without implying a meaning they do not have. If the chart contains only one series, a legend may add little; removing it can free space. If it contains several series, make sure the legend names match the worksheet headings.
Data labels are helpful when readers need exact values, especially in a small chart or a presentation. They can clutter a chart with many columns, though. Use them selectively, and check that labels do not overlap. Axis titles are useful when the measurement or unit is not obvious. For the example, Product could label the category axis and Units sold the value axis.
Check the value-axis scale before sharing the chart. A vertical axis that starts above zero can make modest differences look dramatic because column height is judged from its base. For ordinary column comparisons, a zero baseline is often the most intuitive choice. If a different bound is necessary, make the scale apparent and explain why it is used. Also avoid excessive gridlines, decorative backgrounds, and too many colors; they distract from the relative heights that carry the information.
Switch rows and columns or update the source
If Excel displays one column per product instead of one pair per product, the program may have interpreted the rows as series and the columns as categories. Select the chart and choose Chart Design > Switch Row/Column. This changes how the existing range is plotted; it does not rearrange or alter the worksheet data. Check the legend and category labels afterward to confirm the chart answers the intended question.
To include more data, select the chart and adjust its source through Chart Design > Select Data, then revise the chart data range or series details in the dialog. Another practical option is to format the source range as an Excel table using Insert > Table. Charts based on a table can incorporate new rows added to that table, which is useful for recurring reports. Check the finished chart when adding data, because an added column or a changed heading may affect the series and legend.
Common column chart problems
- The chart has no useful labels: Include the heading row and category column in the selected range. If labels are still wrong, use Chart Design > Select Data to inspect the category axis labels and series names.
- Categories and series are reversed: Try Chart Design > Switch Row/Column. This is common when the data has more categories arranged across columns than down rows.
- Some values are missing: Check whether the source cells are blank, contain text instead of numbers, or fall outside the selected range. A number stored as text may not plot as expected.
- The chart is crowded: Reduce the number of categories, remove unnecessary labels, or consider a horizontal bar chart if long category names are difficult to read.
- Differences look exaggerated: Review the vertical axis bounds and whether the value axis starts at zero. Explain any nonzero baseline so readers do not mistake visual scale for a large change.
One frequent misconception is that every chart must start at zero. The better principle is to choose a scale that represents the values honestly and makes the comparison understandable. For columns, a zero baseline is usually important because the visual comparison depends on column length. If the range is narrow and a nonzero minimum is used, viewers need to see that clearly.
Column chart versus bar chart
Column and bar charts use similar visual encoding, but their bars run in different directions: columns are vertical, while bars are horizontal. A column chart is a natural fit for a short sequence of periods or a few categories. A bar chart often works better for long category names or a longer ranked list, because the labels can fit beside horizontal bars without being rotated or squeezed. Excel places both choices under Insert Column or Bar Chart, so the chart family is easy to compare.
Neither chart type is automatically better. Consider the category labels, number of groups, and comparison the reader needs to make. If the data is chronological and you want to emphasize a continuous pattern over many points, a line chart may be a stronger alternative. If values are parts of a whole, a stacked chart can help, but only when the totals and component relationships matter.
Frequently Asked Questions
How do I make a column chart in Excel?
Select the category labels, headings, and values. Then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Add a descriptive title and check that Excel assigned the categories and series correctly.
How do I add another data series to a column chart?
Add the new headed values beside the existing source data, then update the chart through Chart Design > Select Data if the new column is not included automatically. Confirm that the series appears in the legend and that its values line up with the intended categories.
What is the difference between a column chart and a bar chart?
A column chart uses vertical columns; a bar chart uses horizontal bars. Columns often suit a small number of categories or periods, while horizontal bars can be easier to read when category names are long.
Can a column chart show percentages?
Yes. You can chart percentages as values, provided the cells contain numeric percentages and the axis or labels make the measure clear. Use a 100% Stacked Column chart only when you want to compare each category’s composition as proportions totaling 100 percent.
How can I make a column chart update when I add rows?
One useful approach is to format the source range as an Excel table with Insert > Table, then base the chart on that table. When you add data as a new table row, the chart can include it; verify the chart after changes to make sure the new category is displayed as intended.
Related
- Insert an Image Into Excel: Steps and Options
- Can You Insert an Image Into an Excel Cell?
- Can You Delete Duplicates in Excel? Methods and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart With Drop-Down List: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a drop-down with Data Validation, use a helper column…
- Excel Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Excel, list each task with a start date and finish date, place…
- Add Power Pivot to Excel: Enable It and Get StartedTo add Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose…
- Google Sheets Chart Editor: Create and Customize ChartsThe Google Sheets Chart editor is the sidebar for creating and changing charts in a spreadsheet. Select the…
- OEE Waterfall Chart in Excel: Build and Interpret ResultsTo make an OEE waterfall chart in Excel, put the starting 100% and each staged loss in a…
- Power Pivot From Multiple Excel Files: How It WorksYes. In Excel for Microsoft 365 on Windows, use Power Query to import or combine data from multiple…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.