Excel Column Chart: Make Columns Wider and Improve Spacing

To make columns wider in an Excel column chart, select a column, open Format Data Series, and reduce Gap Width under Series Options. For example, changing Gap Width from 150% to 50% makes the columns wider relative to the spaces between them; increasing the chart’s width can also help when many categories are shown.

What controls column width in Excel?

In a standard column chart, Excel places each category in a position along the horizontal axis and draws a column for each plotted series. The Gap Width setting controls the spacing between category groups relative to the columns. A smaller gap leaves less blank space and makes the columns look wider. A larger gap makes the columns narrower and separates groups more clearly.

Gap Width is a percentage setting, not a measurement in inches or pixels. A value of 100% does not mean that a column is 100% of the chart width; it describes spacing in relation to the plotted columns. Excel commonly starts with a gap width around 150%, although the initial value can vary with chart type, workbook, or formatting. Treat the number as a visual control and adjust it while watching the chart.

This setting changes the appearance of the plotted columns, not the source data or the values represented by their heights. It does not make a low value taller, change the axis scale, or alter the data series. If the columns are too thin because the chart contains many categories, chart size and data layout may matter as much as the gap setting.

Make columns wider step by step

Click the column chart to activate it.
Click one of the columns once. Excel should select the entire data series, rather than just one category’s column.
Right-click the selected column and choose Format Data Series. On a Mac, Control-clicking the series opens the contextual menu; the pane is also available after selecting the series.
In the formatting pane, choose Series Options and find Gap Width.
Type a smaller percentage, such as 75% or 50%, and press Enter. If the result is too crowded, raise the percentage again.

In Excel for Microsoft 365 on Windows, the Format Data Series pane opens at the side of the workbook. The option may appear under a chart-series icon, with the exact icon layout depending on the pane width. On Mac, the same setting is available in the Format Data Series pane, though the contextual menus and pane arrangement can look different. Excel for the web also offers chart formatting controls, but available chart options and their layout may differ from the desktop app; use desktop Excel if the Gap Width control is not available in your browser version.

Choose a useful Gap Width value

There is no single best percentage. The right setting depends on how many categories and series the chart contains, how large the chart is, and whether the viewer needs to compare individual values or see a general pattern. Make a modest change first, then check the chart at the size at which it will actually be read.

About 150%: Often a reasonable starting point when you want visible separation between category groups.
About 75% to 100%: A useful range to try when columns look too thin but should remain distinct.
About 25% to 50%: Can work for a compact chart with a small number of categories, but may make groups feel crowded.
0%: Removes the gap between category groups. Adjacent columns can touch, so use this only when the resulting visual separation remains clear.

These are starting points, not rules. Excel permits a range of Gap Width values, and changing it affects the chart’s overall rhythm. A very small gap can make a chart look like a solid block, while a very large gap can make each column seem disconnected from the others. If exact readability matters, compare a few settings at the final display size rather than relying on a particular percentage as a universal standard.

Why chart size and category count matter

Gap Width changes spacing within the available plot area. It cannot create more horizontal room. If a chart has four categories, the columns have more room to occupy than a chart with forty categories of the same physical width. With many categories, even a fairly low Gap Width may still leave columns visually narrow because each category has only a small horizontal slot.

Try dragging a chart’s left or right sizing handle to make the chart wider. In a chart embedded in a worksheet, select the chart first and drag a corner or side handle; dragging a corner changes both dimensions, while a side handle changes one dimension. If the chart is on a chart sheet, resizing the Excel window or adjusting the printed page layout can change how much space it receives. Make sure the plot area, where the columns are drawn, has room too: a long legend, title, or axis labels can take space away from it.

For example, imagine a chart showing monthly sales for 24 months. If it is only a few inches wide, lowering Gap Width may help, but the month labels and columns can still feel cramped. A wider chart, shorter date labels, or a view of fewer months at a time may improve readability more than pushing Gap Width close to zero. For a chart with just four annual categories, a moderate reduction in the gap may be enough.

Clustered and stacked charts behave differently

In a clustered column chart, each category can contain several side-by-side columns, one for each series. Gap Width controls the space between category groups. If the columns within a group themselves look too separated or overlap, look at Series Overlap in the same Series Options area. Series Overlap is a different control: it determines how multiple series sit in relation to one another within a category. Increasing overlap brings them closer together; setting them to overlap fully can hide one series behind another, depending on order and formatting.

For example, a chart of quarterly revenue for three regions has four category groups and three columns in each group. Reducing Gap Width brings the four groups closer together and makes the columns wider. Adjusting Series Overlap changes the arrangement of the three regional columns within each quarter. If the goal is to compare all three regions side by side, keep enough separation to identify each column rather than overlapping them.

In a stacked column chart, the data series are segments of one column per category. Gap Width changes the spacing between those stacked columns; it does not make the individual segments into separate side-by-side columns. A 100% stacked chart follows the same spacing principle, even though the column heights represent proportions rather than raw totals. The chart type determines how series are arranged, while Gap Width adjusts the horizontal spacing.

Diagnose common problems

The setting is missing: Confirm that a data series is selected, not the chart title, axis, plot area, or chart background. Right-click an actual column and choose Format Data Series.
Only one column changes: You may have selected a single data point. Click the column once to select its series; if a second click selects one point, click elsewhere on the series and reopen the pane.
Columns remain thin: Check the number of categories and the chart’s width. A large data set squeezed into a small chart may need more space, fewer displayed categories, or a different chart design.
Columns touch or look crowded: Increase Gap Width. In a clustered chart, also check whether Series Overlap is causing the series to sit too close together.
The columns look too tall or short: That is a height or vertical-axis issue, not a width issue. Review the vertical axis scale or chart dimensions rather than changing Gap Width.
Labels become hard to read: Wider columns do not automatically make category labels clearer. Consider shortening labels, rotating them, or showing fewer categories, while keeping the underlying values and labels accurate.

A frequent misconception is that changing the width of worksheet cells changes the width of the columns in a chart. Cell width can affect how the chart object fits in a worksheet if the object is set to move or size with cells, but the plotted column spacing is controlled by chart formatting. Another common detour is changing the vertical axis maximum: that changes the apparent column heights, not their widths.

When another chart adjustment is better

If the chart is intended for close comparison across many categories, making every column wider is not always the best solution. A chart with many tightly packed columns may be easier to interpret if it is made larger, filtered to a relevant time period, or split into smaller charts. A line chart may better show a continuous trend over time, while a bar chart can be more readable when category names are long. Those alternatives change the way the information is presented, so choose them based on the question the chart should answer, not just on column width.

For a small number of categories, a lower Gap Width is usually straightforward. For many categories, consider whether all of them need to appear at once. If the chart is for a report, test it in the actual page or slide layout: a chart that looks clear on a large monitor may become crowded when printed or reduced. Keep enough spacing and contrast for readers to distinguish neighboring categories and series.

Frequently Asked Questions

What is the fastest way to make Excel chart columns wider?
Right-click a column, choose Format Data Series, open Series Options, and lower Gap Width. Try 75% or 50% as a starting point, then adjust until the chart is clear.

Does a lower Gap Width make the columns touch?
It reduces the space between category groups. At 0%, the gap is removed, so adjacent columns can touch. In clustered charts, series arrangement and overlap also affect how columns appear within each group.

Can I make just one column wider?
Gap Width is a series-level setting, so it normally changes the spacing and width for the whole series rather than one selected category. To emphasize one value, consider a distinct fill color or a separate data series, while preserving the chart’s meaning.

Why are my Excel columns still narrow after I reduce Gap Width?
The chart may contain many categories or have a small plot area. Make the chart wider, reduce the number of displayed categories, or adjust labels and legends that take up plotting space. A tiny gap cannot compensate for a chart with too little room.

How do I make columns wider without changing their height?
Adjust Gap Width or the chart’s horizontal size. These affect appearance and available space, not the values plotted or the vertical axis scale. Avoid changing the data or axis limits when you only want to alter column width.

Is Gap Width the same as Series Overlap?
No. Gap Width changes the spacing between category groups. Series Overlap changes how multiple series are positioned relative to each other within a category, which matters especially in clustered column charts.

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.