Column Chart Maker in Excel: Create a Chart

Charts & pivot tables · Updated November 19, 2026

Excel has a built-in column chart maker: arrange categories in one column and their values in another, select the data, then choose Insert > Insert Column or Bar Chart and pick a column chart. Excel creates an editable chart in the workbook; you do not need to install a separate maker.

What Excel’s column chart maker does

A column chart displays values as vertical bars, with categories along the horizontal axis and a value scale along the vertical axis. It is useful for comparing amounts across categories, such as monthly sales, survey responses, product totals, or yearly expenses. The chart is linked to its source cells, so editing those values normally updates the chart.

Excel offers several column chart forms. A clustered column chart places series side by side for comparison. A stacked column chart combines series into totals while showing their component parts. A 100% stacked column chart shows each category as a proportional whole, making it easier to compare composition than absolute size. These are chart types within Excel, not separate applications or add-ins.

For example, a table with months in column A, 2025 sales in column B, and 2026 sales in column C can become a clustered column chart with two bars for each month. The visual makes month-to-month differences easy to scan, though it does not replace checking the underlying figures.

Prepare the worksheet data

Before creating a chart, organize the data as a simple rectangular table. Put category names in the first column and each series of comparable values in its own column. Use a single header row to identify the series. Avoid blank rows or columns inside the range, merged cells, and explanatory notes mixed into the data.

  • Use clear, short headers, such as Month, 2025, and 2026.
  • Keep one category per row, such as one month, department, or product.
  • Enter actual numeric values for charted amounts. Text that looks like a number may not plot as expected.
  • Use consistent units and time periods; do not mix dollars and percentages in the same value series.
  • Keep totals separate from category rows unless you specifically intend to chart the total.

For instance, if A1:C4 contains headers Month, 2025, and 2026, with three months of values beneath them, selecting A1:C4 gives Excel the category labels and two series. If the data is arranged in rows instead, Excel may interpret the series and categories differently. You can correct that after inserting the chart.

Create a column chart in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, use the ribbon to create a chart:

  1. Select the complete data range, including its headers. If the data is in a continuous table, clicking a cell in it may be enough for Excel to detect the range, but selecting it explicitly helps avoid including unrelated cells.
  2. Open the Insert tab.
  3. Choose Insert Column or Bar Chart in the Charts group.
  4. Under 2-D Column, select Clustered Column, Stacked Column, or 100% Stacked Column. For a first comparison of categories, Clustered Column is usually the clearest starting point.
  5. Click the chart to select it, then move or resize it using its border and handles. You can also cut and paste it to another worksheet.

Excel also provides Insert > Recommended Charts. This opens suggested chart types based on the selected data; choose a suitable column option and confirm it. Recommendations can be convenient, but check that Excel has interpreted the category labels and series correctly. In Excel for Mac, the Insert tab also provides chart choices, though the ribbon layout and button names can vary slightly by version. Excel for the web has chart insertion and basic formatting, but some advanced chart controls may be more limited than the desktop app.

Choose the right column chart type

The best chart depends on what the reader needs to compare. A clustered column chart works well when the goal is to compare several series within each category—for example, sales by region across several quarters. With many series or category names, however, the bars can become crowded.

A stacked column chart is appropriate when both total size and the component contributions matter. Since only the bottom series shares a common baseline, it is harder to compare the heights of middle or upper segments across categories. A 100% stacked chart removes differences in total size and emphasizes each series’ share of its category. It can mislead if readers need to compare the actual totals, so consider showing totals separately when those matter.

Column charts generally suit a modest number of categories with labels that fit comfortably. If there are many long labels, a bar chart—with horizontal bars—may be easier to read. For a trend over many evenly spaced dates, a line chart may communicate continuity more clearly. The chart type should reflect the question, not just the shape Excel offers first.

Format the chart for clear reading

Select the chart to show chart-specific ribbon tabs, including Chart Design and Format in the Windows desktop app. Chart Design provides tools for changing the chart type, selecting a layout or style, and adding chart elements. A title should say what is being compared, such as “Quarterly Sales by Region,” rather than the generic “Chart Title.”

To add or edit a title, select the chart and use Chart Design > Add Chart Element > Chart Title. The same menu includes options for axis titles, data labels, gridlines, and a legend. Available choices can depend on the chart type. Use a vertical axis title when the unit is not obvious, such as “Revenue (USD)” or “Responses.” If the series names are already clear from labels, a legend may be unnecessary.

Keep formatting restrained. Use distinct, accessible colors for series, avoid decorative effects that make heights harder to judge, and keep the vertical axis starting at zero for ordinary column comparisons. A nonzero baseline can exaggerate small differences because column length represents magnitude. If you have a specific analytical reason to use a different scale, make that choice prominent and explain it rather than letting it pass unnoticed.

Labels, axes, and chart updates

Data labels can show exact values on the bars. To add them, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a position. Labels help when readers need precise figures, but they can clutter a chart with many categories or series. If the values are already printed in a nearby table, consider whether repeating them adds useful information.

If Excel places the categories and series the wrong way around, select the chart and choose Chart Design > Switch Row/Column. This changes how Excel reads the selected data; it does not rearrange the worksheet. If a series or category is missing, use Chart Design > Select Data to inspect the chart’s data range and entries. When the source range is an Excel table, adding rows to the table can make it easier for charts to include new records, though verify the chart range if it does not expand as expected.

Dates and numbers on an axis can sometimes appear in an unexpected format. Right-click the axis, choose Format Axis, and review the available axis and number-format options. The exact controls vary according to the data and chart type. Avoid forcing a date into a text label simply to change its display if doing so would prevent Excel from treating it as a date.

Common problems and practical fixes

  • The chart is blank or has missing bars: Check that the selected range includes numeric cells and that values are not stored as text. Also inspect the range using Chart Design > Select Data.
  • Headers appear as categories: Include the header row and the category labels when selecting the data. If Excel still reads the range incorrectly, use Switch Row/Column or edit the entries in Select Data.
  • There is an unwanted bar for a total: Remove the total row from the chart’s source range, or adjust the range through Select Data. A grand total is usually not a peer category in a comparison.
  • Category labels are cramped: Enlarge the chart, shorten labels in the source data, reduce the number of categories, or consider a horizontal bar chart.
  • Small differences look dramatic: Check whether the value axis starts at zero. For column charts, a truncated baseline can make modest changes appear much larger.

When changing the source data, remember that the chart is a visual summary, not a separate copy of the numbers. If the chart becomes confusing after a worksheet edit, inspect its source range and series instead of rebuilding it immediately.

Excel chart maker versus other options

Excel’s built-in chart tools are a good fit when the data already lives in a workbook and the chart needs to remain editable alongside it. You can adjust the data, labels, colors, and layout without exporting to another application. For a one-off chart, Recommended Charts can speed up selection, while the Insert Column or Bar Chart menu gives direct control over the chart family.

Other spreadsheet programs also create column charts, and dedicated visualization tools can offer different sharing or dashboard features. The trade-off is that moving data between programs may add steps or change formatting. If you need a static image for a report, Excel can copy or export a chart, but keep the workbook version if readers may need to inspect the data or update the figure.

Frequently Asked Questions

Is there a free column chart maker in Excel?
Excel’s chart tools are included in the application, so a separate chart-maker add-in is not required. Whether you can use Excel without cost depends on your Microsoft account, license, and access method; the chart feature itself is built into Excel.

How do I make a column chart from two columns?
Put category labels in the first column and numeric values in the second, include a header for each, select both columns, then choose Insert > Insert Column or Bar Chart > Clustered Column. Check that the first column supplies the horizontal-axis labels.

What is the difference between a column chart and a bar chart?
A column chart uses vertical bars, while a bar chart uses horizontal bars. Both compare categories, but horizontal bars often accommodate long labels or many categories more comfortably.

Can I change a column chart to a different chart type?
Yes. Select the chart and choose Chart Design > Change Chart Type, then select the alternative. Review the result afterward because a different chart type may interpret or display the same series less clearly.

Why does Excel show the wrong data on my chart?
Excel may have selected the wrong range or treated rows as series when you intended them to be categories. Use Chart Design > Select Data to review the range, or try Switch Row/Column. Confirm the chart title, axis labels, and series names before sharing 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.