How to Create a Custom Column Chart in Excel

To create a custom column chart in Excel for Microsoft 365 on Windows, arrange category labels and numeric values in adjacent columns, select the data, then choose Insert > Insert Column or Bar Chart and select a column chart. Use the Chart Design and Format tabs to change its layout, colors, labels, axes, and other visual details.

Choose the right column chart for your data

A column chart compares values across discrete categories using vertical bars. It is useful for questions such as which product sold the most, how monthly totals compare, or how a result changed across a small number of time periods. The chart type determines how multiple data series are shown, so choose it to match the comparison you want readers to make.

Clustered Column: Places series side by side for each category. Choose it when you need to compare individual series as well as categories, such as sales for three product lines across four quarters.
Stacked Column: Places series on top of one another, showing both a category total and the parts that make up that total. It works best when the component values add to a meaningful whole.
100% Stacked Column: Makes every column the same height and shows each series as a share of its category total. Use it to compare proportions, not absolute totals.
3-D Column: Adds a perspective effect, but that can make bar heights harder to compare. A flat, two-dimensional chart is usually easier to read accurately.

If the categories are long labels or there are many of them, a bar chart—with horizontal bars—may fit better. Column charts are also less effective when a time series contains many periods; a line chart can make a long-term trend easier to see.

Prepare the worksheet data

Clear, consistent source data makes chart creation and later editing more predictable. Put category names in one column and values in the next, with a descriptive heading at the top of each column. For example, cells A1:B5 might contain the headings Month and Orders, followed by January 125, February 148, March 137, and April 162. Select the headings and all four rows when you create the chart.

For multiple series, use one category column followed by a separate column for each series. A table with Quarter, North, and South headings can produce a clustered chart comparing both regions in each quarter. Keep each row aligned: the values in a row must belong to the category shown beside them.

Use one header row and avoid blank rows or columns inside the data range.
Enter numeric values as numbers, not text that only looks numeric. A value stored as text may be omitted or plotted unexpectedly.
Use meaningful category labels, and check for duplicate or misspelled labels that might make the chart confusing.
Decide whether totals, percentages, or individual components answer the question. A 100% stacked chart does not show the absolute size of each total.

Excel tables can make a chart’s source range easier to maintain as rows are added. Select the data and choose Insert > Table, confirm whether the table has headers, and then insert the chart from the table. In Microsoft 365, charts based on an expanding table generally include new table rows as the data grows, but check the chart after major structural changes.

Insert the chart and check its data orientation

Select the source range, including its headings. On the ribbon, choose Insert > Insert Column or Bar Chart, then choose the desired option under 2-D Column, such as Clustered Column. Excel places the chart on the current worksheet. The Insert tab may show a chart icon or menu whose appearance varies slightly with the ribbon layout, but the chart choices are under Insert Column or Bar Chart.

Check the result before styling it. Category labels should appear along the horizontal axis, and each numeric column should appear as a separate series. If Excel has interpreted rows as series and columns as categories, select the chart and choose Chart Design > Switch Row/Column. This changes the chart’s interpretation of the selected range; it does not rearrange the worksheet data.

To edit the source range or select a different range, choose Chart Design > Select Data. In the Select Data Source dialog, you can add, remove, or edit a series and change the category-axis labels. This is also useful if Excel left out a heading or included an unwanted blank row. Make changes to the source data when possible rather than typing values directly into the chart.

For a chart on its own sheet, select the chart and choose Chart Design > Move Chart, then choose New sheet. This is useful for a presentation-sized chart or a print layout. Choose Object in if you want to keep the chart embedded on an existing worksheet.

Customize the chart’s appearance

Select the chart to reveal the contextual Chart Design and Format tabs. Chart Design offers chart type, layout, style, and data-source controls; Format provides controls for selected chart elements, such as a series, title, or axis. The exact galleries and buttons shown can vary with the selected element and window size.

Start with the parts that communicate meaning:

Chart title: Click the title and replace the placeholder with a specific description, such as “Orders by Month.” If the chart has no title, choose Chart Design > Add Chart Element > Chart Title and select a position.
Legend: Keep it when there are multiple series and readers need to identify them. For a single series, it often adds little information; select the legend and press Delete to remove it.
Axis titles: Add them when the units or measure are not obvious. Choose Chart Design > Add Chart Element > Axis Titles, then select the horizontal or vertical title and enter a concise label such as “Orders” or “Revenue ($).”
Colors and styles: Use Chart Design > Change Colors or choose a style in the Chart Styles gallery. For a particular series, select a column, right-click, choose Format Data Series, and use the Fill controls to change its fill.

Use color to distinguish series, not to decorate every bar without purpose. If a single bar needs emphasis, select the series once and then select that individual data point again before formatting it; changing the series fill affects every bar in the series. Keep contrast strong enough that the columns and labels remain readable.

Format axes, labels, and spacing

Axis settings affect how readers interpret the size of differences. Right-click the vertical value axis and choose Format Axis to open its formatting pane. Under Axis Options, you can adjust bounds and units. For ordinary comparisons of positive values, a zero baseline is often important because a truncated axis can exaggerate differences between columns. If you change the minimum bound, make the choice deliberate and clear to readers.

Number formatting can also improve readability. In the Format Axis pane, use the Number section to display an appropriate number format, such as currency or a percentage, when it matches the underlying values. Avoid adding a currency symbol to values that are not monetary. The worksheet’s number format and the chart’s axis format are related but can be adjusted separately.

To label individual values, choose Chart Design > Add Chart Element > Data Labels and select a position, such as Outside End. Labels help when readers need exact values, but can clutter a chart with many columns. If labels overlap, remove them or label only a small number of important points. For a compact chart, use fewer gridlines rather than shrinking text until it is hard to read.

Column width is controlled by the gap between columns. Right-click a column and choose Format Data Series; in Series Options, adjust Gap Width. A smaller gap makes columns wider, while a larger gap leaves more space between them. With multiple series, Series Overlap controls how much the columns in each category overlap. Use modest changes and check that each series remains distinguishable.

Make the chart update and remain useful

A chart is linked to its source data. Changing a plotted value updates the corresponding column, while changing a category label updates the axis label. If you add records outside a normal source range, however, the chart may not include them automatically. Use an Excel table for data that will grow, or update the range through Chart Design > Select Data.

For a chart intended for regular reporting, keep the source data in a predictable structure and avoid manually moving individual columns to imitate a different order. You can change series order in Select Data, and sort the worksheet data when the intended category order should change as well. For months or weekdays, a meaningful chronological order is usually clearer than sorting by value.

Before sharing or printing, check the chart at the size at which it will be viewed. Confirm that the title, category labels, axis units, legend, and any data labels are legible. If you copy the chart into another document, consider whether the chart should remain linked to the workbook or be pasted as a static image; a linked chart can reflect later data changes, while an image will not update.

Common problems and how to fix them

The chart is blank or missing some bars: Check that the intended cells are selected and that values are numeric. Use Chart Design > Select Data to inspect the chart range and series.
Categories and series are reversed: Select the chart and choose Chart Design > Switch Row/Column, then confirm the axis labels and legend.
Dates appear as numbers or in an unexpected order: Check the source cells’ date values and formats, then inspect the horizontal axis options. Make sure Excel is using the intended category labels rather than an unintended set of cells.
One value makes all the other columns look tiny: Look for an unusually large value, an accidental total included in the range, or a data-entry error before changing the axis scale.
The chart looks crowded: Reduce the number of categories, remove unnecessary labels or gridlines, enlarge the chart, or consider a horizontal bar chart if the category names are long.

One common misconception is that changing the chart’s colors changes the underlying values. It does not: chart formatting changes how data is displayed, while edits to worksheet cells change the plotted data. Keep the source values visible and verify them when a chart seems misleading.

Frequently Asked Questions

How do I change a column chart to a bar chart?
Select the chart, choose Chart Design > Change Chart Type, and select a bar chart option such as Clustered Bar. A bar chart uses horizontal bars, which can make long category names easier to read.

How do I make one column a different color?
Select a column once to select its whole series, then select the specific column again to select that data point. Right-click it, choose Format Data Point, and change its fill. If the entire series changes, the whole series was selected rather than one point.

Can I create a column chart with two data series?
Yes. Put category labels in the first column and each series in its own adjacent column, with a heading for each series. Select the full range and insert a Clustered Column chart to compare the series side by side.

Why are my column values showing as percentages?
A 100% Stacked Column chart displays each category as a percentage of its total. If you need to compare actual values, choose Clustered Column or Stacked Column instead. Also check whether the source cells are formatted as percentages.

Are the steps different in Excel for Mac or Excel for the web?
The basic process is similar: select the data and use the Insert tab to add a column chart. Ribbon placement and some formatting controls differ by platform and window layout. The Windows paths in this guide refer to Microsoft 365 for Windows; look for the corresponding chart design and format controls in the Mac or web ribbon.

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.