If the columns in an Excel chart look too narrow, select a column in the chart, open Format Data Series, and reduce Gap Width under Series Options. A smaller gap makes the columns wider; if the chart’s plot area is cramped, widen the chart or make more room for the plot area as well.
What Gap Width Controls
Gap Width sets the space between the columns for neighboring categories, expressed as a percentage. In a simple chart with one series, lowering the percentage narrows the gaps and gives each column more width. Raising it does the opposite. A value of 0% removes the gaps between categories, so the columns touch; that may suit a particular design, but it can make categories harder to distinguish.
Excel’s usual default is 150%, though the starting value can vary with the chart and workbook. There is no single ideal setting. A reduction such as 150% to 75% is a useful first adjustment, not a rule: try a few values and judge the chart at the size where people will read it. Gap Width changes the columns’ proportions, not the size of the chart itself or the space available for its axes and labels.
Make Columns Wider in Excel for Windows
In Excel for Microsoft 365 on Windows, use the chart’s series formatting pane:
- Click the chart, then click one of its columns. The first click selects the chart; clicking a column selects the data series. If there are multiple series, click a column from the series you want to change.
- Right-click the selected column and choose Format Data Series. Alternatively, press Ctrl+1 after selecting the series to open its formatting pane.
- In the pane, select Series Options, represented by a column-chart icon if the pane displays icons.
- Find Gap Width and enter a smaller percentage, or use its slider if one is shown. For example, try 75% instead of 150%.
- Click outside the pane and inspect the chart. If the columns still look cramped, check the chart’s overall dimensions and labels before lowering the gap further.
The right-click command matters: formatting the chart area or plot area will not show the series’ Gap Width setting. If you cannot find it, click an actual column rather than the chart background, title, legend, or axis. In a stacked chart, select a segment belonging to the series you want to format.
Choose a Gap Width That Fits the Chart
Use the chart’s purpose and number of categories to choose a setting. Columns need enough space between them to read as separate values, but excessive gaps can make a small chart feel thin and disconnected. Consider the data labels too: wider columns can give labels more room, while labels placed inside very narrow columns may overlap or become difficult to read.
- For a short chart with a few categories: A lower setting can make the columns more substantial. Compare settings around 50% to 100% and check whether the gaps still separate the categories clearly.
- For many categories: Reducing the gap can help, but it cannot create unlimited space. If dozens of categories are squeezed into a small chart, the columns may remain thin because each category has little horizontal room.
- For a report or presentation: Check the chart at its final printed or on-screen size. A setting that looks good while editing at a large zoom may not work when the chart is reduced.
As a concrete example, suppose a chart has six monthly categories and the gaps look much larger than the columns. Change Gap Width from 150% to 75%. The columns become wider relative to their gaps, but the chart still has six category positions and the same overall width. If it has 24 categories instead, the same adjustment may help only modestly; increasing the chart width or showing fewer categories may produce a more readable result.
Check Whether the Chart Itself Is Too Small
A narrow column is not always a gap-width problem. Excel divides the chart’s plot area among its categories and series. If the plot area is narrow, each category has less room, regardless of the Gap Width setting. The plot area is the region where the columns and axes appear; titles, a legend, and axis labels can take up space around it.
First, drag a corner or edge of the chart to make the chart larger. If the chart sits inside a worksheet cell or a dashboard layout, make sure there is room for that increase. You can also select the plot area and drag its handles to give it more space, though taking space away from labels or the legend can make those elements crowded. A wider chart is often a better fix than setting the gaps almost to zero.
Long category names can also consume room. For example, a chart with full product names along the horizontal axis may reserve substantial space for angled or wrapped labels. Shortening labels in the source data, rotating axis labels, or moving the legend can help the plot area. Avoid shrinking text so much that the chart becomes difficult to read.
Understand Multiple Series and Overlap
A clustered column chart displays multiple series side by side within each category. For example, each month might contain separate columns for two regions. The category position is shared, so the available width is divided among the series as well as the gap between categories. That means each individual column can look narrow even when the gap setting seems reasonable.
In Format Data Series > Series Options, Excel may also show Series Overlap. This setting controls how much columns from different series overlap within a category; it is separate from Gap Width. Increasing overlap can make clustered columns occupy less of the category’s horizontal space, while moving it toward a side-by-side arrangement can give each series a distinct position. The exact visual effect depends on the chart type and number of series. Use it deliberately: overlapping columns can hide values and make comparisons harder.
For a stacked column chart, series are placed on top of one another rather than side by side. Gap Width still affects spacing between categories, but it does not turn a stack into a set of wider clustered columns. If a chart contains a secondary axis or a combination of chart types, series may be grouped or positioned differently. Check the selected series and chart type before assuming one setting will affect every column in the same way.
Fix Other Causes of Thin or Crowded Columns
Before making a very large Gap Width change, check the chart’s source data and layout. Extra categories, blank rows included in the chart range, or a chart that contains more series than intended can make columns appear cramped. Select the chart and use Chart Design > Select Data to inspect the chart data range and the listed series and category labels. Remove unintended data from the chart range or edit the series and category references as needed.
Other useful checks include:
- Chart type: Confirm that the chart is a column chart rather than a different chart type. To change it, select the chart and choose Chart Design > Change Chart Type.
- Category count: If the chart shows every day in a long period, consider displaying a shorter period or summarizing the data by week or month.
- Legend and title: A large legend or long title can reduce the room available for the plot area. Move, shorten, or remove an element only if the chart remains understandable without it.
- Data labels: Labels can collide even after columns are widened. Consider whether every value needs a label, or whether axis values communicate the information more clearly.
Changing chart data or formatting does not alter the underlying worksheet values, but it can change what the chart communicates. Check that the categories and series still represent the intended comparison after editing.
When a Different Chart Is a Better Choice
Some charts are simply asked to display more categories than their available space can support. If reducing Gap Width makes the columns touch but the labels are still unreadable, consider changing the presentation instead of squeezing the chart further.
A horizontal bar chart can accommodate long category names because the labels run beside the bars rather than beneath narrow columns. In Excel, select the chart and choose Chart Design > Change Chart Type, then choose a bar chart. For values measured over time, a line chart may communicate a trend more clearly than many thin columns, especially when the order and continuity of the time series matter. If exact comparisons for every category are essential, split the data into several smaller charts or show a filtered subset.
Keep the reason for the chart in view. Column charts are useful for comparing discrete categories, but making every bar wider is not automatically an improvement. The goal is a clear comparison, with enough separation to identify categories and enough room for the information readers need.
Mac and Excel for the Web
On Excel for Mac, select a column and open Format Data Series from its context menu. In the formatting pane, look under Series Options for Gap Width. The pane’s layout can differ from Windows, but the setting has the same purpose. Keyboard shortcuts for opening formatting panes can vary by Mac keyboard and Excel configuration, so the context-menu route is a dependable alternative.
Excel for the web has chart editing and formatting features, but the available controls can depend on the chart and the current web interface. Select the series and look in the chart formatting options for Gap Width. If the control is unavailable for that chart, open the workbook in the desktop Excel app to adjust the series setting. Menu labels and pane layouts can change between platform updates.
Frequently Asked Questions
What Gap Width should I use in Excel?
There is no best value for every chart. Try lowering the current percentage in small steps, such as from 150% to 100% and then 75%, and keep the setting that makes the categories clear at the chart’s final size.
Can I make Excel columns wider without changing the chart size?
Yes. Reduce Gap Width to make columns wider relative to the gaps. This does not enlarge the plot area, however, so a chart with many categories may still have thin columns.
Why can’t I see the Gap Width option?
You may have selected the chart, plot area, or axis instead of a data series. Click one of the columns, right-click it, choose Format Data Series, and open Series Options. Some chart types may not expose the same options.
Does a lower Gap Width change my data?
No. It changes the chart’s appearance, not the worksheet values. Still, review the result to ensure touching or nearly touching columns do not make categories look like one continuous block.
Why are columns still thin after I reduce Gap Width?
The chart may have too many categories, a narrow plot area, or multiple clustered series sharing the available width. Enlarge the chart, simplify the category labels, show fewer categories, or consider a bar or line chart if it better suits the comparison.
Related
- Convert H:M:S to a Number in Excel
- Contact Number List Template for Excel: Setup Guide
- Contacts List Template Excel: Build a Useful Workbook
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Adjust Column Width in Excel Charts and WorksheetsTo make columns wider or narrower in an Excel chart, select a chart column, open Format Data Series,…
- Manual Sort Pivot Chart in Excel: Control Category OrderTo manually sort a PivotChart in Excel for Microsoft 365 on Windows, reorder the chart’s categories in its…
- New Excel Charts for Dashboards: What to UseYes. Excel for Microsoft 365 includes several chart types that can make dashboards more informative, including waterfall, funnel,…
- Excel Pivot Tables: Analyze Data with Examples and InsightsYes—an Excel PivotTable analyzes a list by summarizing its values and letting you rearrange, filter, group, and compare…
- Excel Stacked Bar Chart: How to Create and Read OneTo make a stacked bar chart in Excel for Microsoft 365 on Windows, select your category labels and…
- Excel Gantt Chart Template: Build and Customize OneAn Excel Gantt chart template is a worksheet that lays out tasks against dates, then uses colored cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.