Custom Column Chart in Excel: How to Build and Format

To make a custom column chart in Excel for Microsoft 365 on Windows, select your category labels and values, choose Insert > Insert Column or Bar Chart > 2-D Clustered Column, then use the Chart Design and Format tabs to adjust its data, labels, colors, axes, and layout. Excel does not have a separate chart type called a custom column chart; you create one by tailoring a standard column chart to the information and audience.

What makes a column chart custom?

A column chart uses vertical bars to compare values across categories. A custom version is simply a chart whose structure and appearance have been deliberately configured: it may show multiple series, use a meaningful title, display selected data labels, apply consistent colors, or omit visual elements that distract from the comparison. Customizing the chart does not change the source data or make the chart a different statistical method.

Column charts work especially well when the categories are discrete and the values can be compared on a common scale. For example, a monthly report might compare sales for four products, or a school chart might compare enrollment across several years. If the categories represent continuous time and the main point is the shape of a trend, a line chart may be easier to read. If each category has many series, a clustered column chart can become crowded, so a different layout may be preferable.

It helps to distinguish a column chart from a bar chart in Excel. A column chart has vertical bars; a bar chart has horizontal bars. The commands for inserting them share a menu, but the orientation affects readability. Long category names often fit better beside horizontal bars, while a small number of short labels can work well under vertical columns.

Prepare the worksheet data

Good chart design starts with a clear table. Put category names in the first column and each series name in its own header cell across the top. Keep each row tied to one category and avoid blank rows or columns inside the selected range. For example, a table might have Month in A1, North in B1, and South in C1, followed by one month per row and the corresponding values in each region column.

Before inserting the chart, check that Excel can identify the labels and values correctly. Include the header row and category-label column in the selection. Use consistent units across a series: do not mix dollars and percentages on the same axis unless the chart is deliberately designed to handle different scales. If you have a total row, decide whether it belongs in the comparison. Including a grand total alongside its component categories often creates a misleadingly tall column.

Use concise, descriptive column headings because Excel may use them as legend entries.
Use one category per row and one data series per column for a conventional clustered chart.
Check for text values, missing observations, and accidental totals in numeric columns.
Keep category order meaningful, such as chronological order or descending value, rather than relying on an arbitrary sort.

When the table is likely to grow, consider converting it to an Excel table first: select a cell in the data and choose Insert > Table, then confirm whether the range has headers. A chart based on a table can include newly added rows as the table expands, although it is still worth checking the chart after changing the source layout.

Insert a basic column chart

On Windows, select the chart data and choose Insert > Insert Column or Bar Chart > 2-D Clustered Column. The chart appears on the worksheet. The clustered option places series side by side within each category, which makes their values easier to compare. If only one series is selected, each category receives one column.

Click the chart to reveal the contextual Chart Design and Format tabs. Start on Chart Design. Choose Add Chart Element to add or adjust elements such as a chart title, axis titles, data labels, gridlines, or a legend. The exact set of available controls can depend on the chart type and the selected element. You can also use the Chart Elements button beside the chart, shown as a plus sign in many Windows installations, for quick access to common elements.

If Excel assigned the data series and categories the wrong way around, choose Chart Design > Switch Row/Column. For finer control, choose Chart Design > Select Data. In the Select Data Source dialog, you can change the chart data range, add or remove a series, edit a series name or values, and adjust the category labels. This is useful when the worksheet contains extra columns that should not appear in the chart.

On Excel for Mac, the chart commands are also available from the Insert tab, and clicking the chart reveals chart-specific tabs such as Chart Design and Format. Ribbon wording or placement can vary slightly by update. Excel for the web supports creating and editing many standard charts, but some detailed formatting options may be more limited than in the Windows desktop app.

Format the columns and chart area

To change the appearance of the bars, right-click a column and choose Format Data Series. In the Format Data Series pane, use Fill & Line to set a solid fill or border, and Series Options to adjust settings such as Gap Width. A smaller gap makes columns look wider; a larger gap makes them narrower. Avoid making columns so wide that adjacent categories look like one continuous shape, or so narrow that the chart feels sparse.

For a multi-series chart, use color to help readers distinguish series, not to decorate every bar independently. A restrained palette with clearly different colors is usually easier to interpret than many bright colors. If the series have a natural meaning—such as actual and target—use that meaning consistently across reports. To emphasize one important category, you can select an individual data point and format it separately, but explain the emphasis in a title, note, or legend if it could otherwise be mistaken for a different series.

Use Chart Design > Change Colors to apply a coordinated palette, or choose a style from the Chart Styles gallery. These are starting points rather than rules: review contrast, text size, and whether the chart still reads clearly when printed in grayscale. To change the background or border, select the chart area and use the Format tab or the Format Chart Area pane. Formatting the chart area changes the space around the plot; formatting the plot area changes the region where the columns and axes appear.

One common customization is to remove the chart border or reduce unnecessary gridlines. Gridlines can help readers estimate values, especially when columns are close in height, but too many dark lines compete with the data. Keep only the lines that make comparisons easier. A clean chart is not necessarily a chart with no context: retain the axis, units, and other information needed to understand the numbers.

Set titles, axes, labels, and legend

A useful chart title tells the reader what is being compared, not merely that the graphic is a column chart. For example, Quarterly orders by product is more informative than Sales chart. If values have units, state them in an axis title or in the chart title when that keeps the graphic self-contained. Use Chart Design > Add Chart Element to add axis titles and data labels; select a title or label on the chart to edit its text.

For a vertical column chart, category names run along the horizontal axis and values run along the vertical axis. Excel usually chooses an appropriate value scale, but you can right-click the value axis and select Format Axis to set bounds, units, number formatting, and other axis options. Do not set a minimum above zero casually: truncated columns can exaggerate small differences because their visible heights no longer start from a common baseline. A nonzero baseline can be appropriate for some analytical views, but it should be intentional and clearly understood.

Data labels can show exact values without requiring the reader to estimate each column against gridlines. Add them through Chart Design > Add Chart Element > Data Labels, then choose a position. Labels are most useful when there are few columns or exact values matter. With many bars, labels can overlap and make the chart harder to scan. If the numbers are large, right-click the value axis, choose Format Axis, and review its number format so it uses suitable units and decimal places.

A legend is useful when the chart contains more than one series. With a single series, it is often redundant because the title and axis explain the data. If the legend takes up space or is far from the series, use Chart Design > Add Chart Element > Legend to change its position or remove it. The series headers in the source table commonly provide the legend text, so clear headers make the key easier to read.

Choose the right column-chart arrangement

Excel offers several column-chart arrangements, each suited to a different question. Clustered columns place series side by side, making direct comparisons between series within each category straightforward. Stacked columns combine series into one column per category, showing both the total and each part’s contribution. A 100% stacked column chart scales each category to 100%, which highlights proportions but hides differences in overall totals.

For example, suppose a store tracks online and in-store orders for several months. Clustered columns help compare the two channels month by month. Stacked columns show the combined monthly order total while preserving the channel components. A 100% stacked chart answers a different question: what share of each month’s orders came from each channel? If one month had 100 orders and another had 1,000, their columns will still have equal total height in a 100% stacked chart.

To change the arrangement, select the chart and choose Chart Design > Change Chart Type, then select the column subtype that fits the comparison. A combo chart may be useful when series have different units or very different scales, but adding a secondary axis can make relationships harder to interpret. Use it only when the axes are labeled clearly and the visual comparison is meaningful. Changing chart type does not repair unsuitable data; confirm that each series and its units support the intended comparison.

Fix common column-chart problems

If the chart shows the wrong categories or series, check the selected range and use Chart Design > Select Data. Switch Row/Column can correct a table where Excel interpreted rows as series when columns were intended, or vice versa. Also check that the first row and first column contain the headers and labels you expect. Blank or merged cells in the source can make chart interpretation less predictable.

If columns appear as one solid block, increase Gap Width in Format Data Series. If they look too thin, reduce the gap or make the chart wider. If category labels overlap, widen the chart, shorten the labels in the source, rotate the labels using the Format Axis pane, or use a horizontal bar chart. Rotating labels can save space, but too much rotation slows reading.

If the values seem misleading, inspect the value-axis bounds and number format. A very large value can compress the smaller columns; a mistaken percentage format can make ordinary values look like percentages. Confirm the underlying cells, units, and axis scale before changing colors or styles. If a newly added row does not appear, check whether the chart’s source range includes it; for charts based on ordinary ranges, you may need to extend the range through Select Data.

Finally, check the chart at its intended size. A chart that looks readable on a large monitor may be too small when placed in a report or slide. Keep labels legible, avoid relying on color alone to identify important groups, and provide a clear title or surrounding explanation. If accessibility matters, add alternative text using the chart’s context menu or the available Alt Text command, and make sure the chart’s message is also conveyed in nearby text or a data table.

Frequently Asked Questions

How do I make a custom column chart in Excel?
Select the category labels, headers, and values, then choose Insert > Insert Column or Bar Chart > 2-D Clustered Column. Use Chart Design, Format, and the Format Data Series pane to customize the chart elements and appearance.

How do I change the color of one column?
Select the series once, then select the specific column again to target that data point. Right-click it, choose Format Data Point, and change its fill in the formatting pane. The point-level selection is important; formatting the series changes every column in that series.

How can I add values above the columns?
Select the chart and choose Chart Design > Add Chart Element > Data Labels, then choose a position such as Outside End. If labels overlap, remove them or show fewer details rather than shrinking the text until it is difficult to read.

What is the difference between clustered and stacked columns?
Clustered columns place series side by side to compare their values. Stacked columns combine series into totals and show the parts within those totals. A 100% stacked chart compares percentage composition, not the size of the totals.

Can I make a column chart update when I add data?
Using an Excel table as the chart source can help the chart include new rows as the table expands. For a chart based on a regular cell range, check Chart Design > Select Data and extend the chart data range when you add categories.

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.