If an Excel column chart looks too skinny, select a column, right-click it, choose Format Data Series, and reduce Gap Width under Series Options. A smaller gap makes the columns wider; if they still look narrow, check the chart’s plot area, category count, and number of data series.
Change the Gap Width in Excel
In Excel for Microsoft 365 on Windows, Gap Width is the main control for the space between category columns. You can change it without changing the worksheet data or rebuilding the chart.
- Click a column once to select the whole data series. If you click a column again, Excel may select only that individual data point instead.
- Right-click the selected column and choose Format Data Series. The formatting pane opens at the side of the workbook.
- In the pane, select Series Options, then find Gap Width.
- Lower the percentage and press Enter. For example, change 150% to 75% and see whether the columns are easier to compare.
There is no single ideal percentage. Try a moderate change first, then adjust based on the number of categories and the available chart width. A setting of 0% removes the gaps, but columns that touch can be difficult to distinguish, especially when they have similar colors. If you cannot see the setting, make sure you selected a column series rather than the chart title, axis, or chart area.
On Excel for Mac, select or Control-click a column and open Format Data Series; Gap Width is in the series options in the formatting pane. The names and pane layout can vary slightly by release. Excel for the web has chart-formatting controls, but if the series options you need are not available in your browser, open the workbook in the desktop app.
What Gap Width Controls
Gap Width controls the spacing between category groups in a column chart. Excel expresses it as a percentage: reducing the percentage generally makes columns wider relative to the gaps, while increasing it makes them narrower. The percentage is a formatting setting, not a direct measurement in pixels or a guarantee that every column will have a particular screen width. The chart’s plot area and data layout affect the result.
For example, a chart with six monthly categories can give each category more horizontal room than a chart of the same size with 30 categories. Even if both use the same Gap Width setting, the individual columns in the second chart will look thinner because many more category positions must fit across the plot area.
The control applies to a series and can affect how the categories in that chart are spaced. In a chart with multiple series, it is useful to distinguish the gap between category groups from the spacing between the series within each group. Gap Width is not the same as Series Overlap, which controls how multiple series align with one another.
Choose a Gap Width That Fits the Chart
Use the chart’s purpose and density to choose a setting rather than applying one percentage to every workbook. A presentation chart with a few categories can usually support more visual breathing room. A compact chart with many categories may need narrower gaps, but making the columns too wide can cause neighboring groups to run together.
- Few categories: Keep some space between columns so the groups are visually distinct. A setting near the default can be a reasonable starting point.
- Many categories: Reduce Gap Width in small increments and check that individual columns remain distinguishable.
- Labels or values inside columns: Leave enough room for the text to be readable. Widening bars cannot solve every label-crowding problem.
- Small chart on a dashboard: Consider increasing the chart’s width before setting the gaps extremely low.
These are starting points, not rules. The same setting can look different on a wide monitor, in a printed report, or after a chart is resized. Check the chart at the size and scale where readers will actually see it.
Separate Cluster Spacing from Series Overlap
A clustered column chart places two or more series side by side for each category. If each bar within a cluster is too narrow, the issue may be the number of series rather than only the gap between categories. For instance, comparing four products across 12 months requires 48 columns in the plot area. Each month’s group has to accommodate four bars, so the bars can look thin even after Gap Width is reduced.
In Format Data Series, Series Overlap controls how the bars from different series sit within each category. Increasing overlap brings the series closer together and can cause them to cover one another; changing it does not simply widen the chart’s category groups. Use overlap carefully, since hidden bars can make comparisons misleading. If the aim is to compare series side by side, preserve that clear arrangement and instead make the plot area wider, reduce the number of series, or consider a different chart layout.
For a stacked column chart, series are placed on top of one another rather than side by side, so Series Overlap is not usually the remedy for a thin-looking column. Gap Width and the chart’s available width remain more relevant. If a stacked chart has many narrow categories, consider whether every category needs to appear at once.
Make More Room in the Plot Area
Gap Width cannot create horizontal space that the chart does not have. Drag a chart’s side or corner sizing handle to make the chart wider, then review the columns. The chart area is the whole object, while the plot area is the interior region where the columns are drawn. A legend, long axis labels, or other chart elements can consume room and leave a narrow plot area inside an otherwise large chart.
If the plot area appears cramped, try these adjustments:
- Move a legend to the top or bottom, or remove it if the series are already clearly identified elsewhere.
- Shorten category labels in the source data when doing so preserves their meaning.
- Use a wider chart layout, particularly when the chart has many categories.
- Reduce unnecessary titles or labels that take up space, while keeping information readers need to interpret the data.
Resizing the chart may change how axis labels wrap or how the legend is arranged, so check the complete chart after making it wider. Avoid shrinking the text so much that the chart is technically less crowded but harder to read.
Check Category Labels and Date Axes
Long category labels do not directly set Gap Width, but they can make the chart feel crowded and reduce the room available to the plot area. If labels overlap or wrap, shortening them, enlarging the chart, or changing their text direction can help. Do not remove labels that are necessary to identify the categories; if there are too many, showing a smaller, meaningful selection may be clearer.
Date-based categories can need a separate check. A category axis displayed as a date axis spaces dates according to time, so gaps in the dates or uneven intervals can produce spacing that does not resemble a simple sequence of equally spaced categories. If each date should have equal spacing regardless of elapsed time, select the horizontal axis, open Format Axis, and check Axis Options for the axis type. Choosing Text axis treats the labels as categories rather than spacing them as a continuous timeline. This changes the meaning of the display, so use it only when equal category spacing represents the data correctly.
Diagnose a Thin Chart with a Quick Example
Suppose a chart shows weekly sales for 20 weeks. The chart is only six inches wide, and each week has three side-by-side series. The columns may look extremely narrow for several reasons at once: many categories, three bars per category, and a limited plot area. Reducing Gap Width can help, but it will not eliminate the space required for all 60 bars.
A practical sequence is to widen the chart, reduce Gap Width moderately, and verify that the legend and category labels are not taking most of the space. If the individual series are still difficult to compare, ask whether all 20 weeks must be shown in one chart. A chart for a shorter time range, a line chart for trends over time, or separate charts for related measures may communicate the pattern more clearly. The best choice depends on whether readers need to compare individual weekly amounts or follow changes over time.
For a different example, a chart with five categories and one series can look skinny simply because Gap Width is high. Lowering it may be all that is needed. The useful diagnostic is to consider how many bars must fit across the plot area before changing settings at random.
Common Fixes That Do Not Address the Cause
Changing the vertical value axis scale will not normally widen the columns. That axis controls how values map to height, not the horizontal spacing of categories. Likewise, increasing a column’s height by changing the data or axis bounds is not an appropriate fix for a width problem.
Another common misunderstanding is that a larger Gap Width makes wider columns. It does the opposite: a larger percentage generally means more separation and narrower columns. Also, selecting an individual data point and changing its formatting may affect only that point’s appearance, while Gap Width is a series-level option. If only one bar appears different, check whether an individual point was selected or formatted separately.
Finally, do not set the gap to zero just because it makes the columns fill the chart. Touching columns can make category boundaries unclear and reduce the visual distinction between groups. Use zero only when the continuous block-like appearance is appropriate and the categories remain understandable.
Frequently Asked Questions
What is the default Gap Width in an Excel column chart?
Excel commonly uses a Gap Width of 150% for column charts, though the value can vary with chart type or formatting. Select a series and inspect Format Data Series to see the setting used in your chart.
What Gap Width should I use?
There is no universal best value. Start with the current setting, reduce it gradually, and judge the result at the chart’s final display size. Leave enough space to distinguish categories and avoid overlapping labels.
Why are my columns still thin after I reduce Gap Width?
The chart may contain many categories or several series per category, or its plot area may be narrow because the chart is small or has a large legend. Widen the chart and review the number of categories and series as well as the gap setting.
Can I make just one column wider?
Gap Width is generally a series-level control, so changing it affects the series rather than independently widening one category. You can format an individual data point for appearance, but that is not a general way to change its physical column width. For a one-off emphasis, use a clear color or data label instead.
Does Gap Width change the data or the chart scale?
No. It changes the chart’s visual spacing, not the source values or the value-axis scale. Readers should still be able to tell which category each column represents.
Should I use a column chart when there are many categories?
It depends on what the chart needs to show. If readers must compare discrete categories, a column chart may still fit, but a wider chart or fewer displayed categories can help. For a time trend with many dates, a line chart may be easier to read.
Related
- ICD-10 Z Codes List in Excel: Find, Import, and Check
- Excel Color Scales: How Conditional Formatting Works
- Close Excel Shortcut Key for Windows and Mac
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Sort Excel Chart Data and Reorder Categories EasilyTo sort an Excel chart, sort the chart’s source data: select a cell in the data, choose Data…
- Excel Pivot Table Add to Data Model: A Practical GuideTo add data to the Excel Data Model, select a cell in your source range, choose Insert >…
- Excel Change Pivot Table Data Range: Steps and FixesTo change a PivotTable’s source range in Excel for Microsoft 365 on Windows, click inside the PivotTable, choose…
- Excel Line Chart Smooth Curve: Setup, Limits, and TipsYes. In Excel for Microsoft 365 on Windows, select a line in the chart, open Format Data Series,…
- Bar Chart by Month in Excel: Create, Format, and ReadTo make a month-by-month chart in Excel, put each month in one column and its value in the…
- Excel Histogram Custom Bins: How to Set ThemIn Excel for Microsoft 365 on Windows, select your numeric data, choose Insert > Insert Statistic Chart >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.