Excel Bar Graph Too Skinny? Fix Bar Width and Spacing

If an Excel bar graph looks too skinny, select a bar, open Format Data Series, and reduce Gap Width under Series Options. A smaller percentage makes bars thicker; if that does not help enough, check the chart’s size, number of categories, and number of plotted series.

What “too skinny” means in an Excel chart

In Excel, a bar chart displays values with horizontal bars, while a column chart displays them with vertical bars. People often use “bar graph” for either one, and the main spacing control works similarly on both: Gap Width. It controls the space between category groups, not the size of the values or the scale of the value axis.

A chart can look thin for several different reasons. There may be a large gap between categories, many categories squeezed into a short chart, several series sharing each category, or simply too little room in the chart area. Identifying which condition applies matters: lowering Gap Width is a quick fix for spacing, but it cannot make a crowded chart readable by itself.

For example, a chart with four monthly categories has ample room for substantial bars. A chart with 40 product names in the same chart object must divide its plotting space among many more positions. Even with a low Gap Width, those bars can look narrow, and the labels may be difficult to read.

Quick fix: reduce Gap Width

In Excel for Microsoft 365 on Windows, use these steps:

Click the chart, then click one of the bars in the series you want to change. If there are several series, clicking again may select an individual data point rather than the whole series; select the series, not just one bar.
Right-click the selected bar and choose Format Data Series. The Format Data Series pane opens.
In the pane, choose Series Options, usually shown with a small column-chart icon, and find Gap Width.
Lower the percentage. For example, change 150% to 75%, then press Enter or click elsewhere to apply it. If the bars still look thin, try 50% or 25% and compare.

Gap Width is a percentage-based spacing setting. Lower values reduce the gaps and make the bars or category groups wider; higher values create more separation and make them look thinner. A setting of 0% removes the gap between category groups, which can make adjacent bars touch. That is usually too dense for a chart with many categories, so adjust gradually rather than assuming the smallest possible value is best.

The commonly seen starting value for a standard chart is 150%, but defaults and existing workbook formatting can vary. Treat the value already shown in the pane as the starting point, not as a rule that every chart must follow.

What Gap Width changes—and what it does not

Gap Width changes the width of the plotted bars relative to the available category spacing. It does not change the source values, their order, the value-axis scale, or the actual chart dimensions. A bar still represents the same number after you adjust this setting; only its visual thickness and the empty space around it change.

This distinction helps diagnose a common misconception: a short-looking bar is not necessarily a skinny bar. If a bar’s length seems too short, check the value axis, the data, and whether the chart is comparing the intended values. Gap Width addresses thickness and spacing, not bar length. Conversely, changing the value-axis minimum or maximum can alter apparent lengths but will not make a bar physically thicker.

Gap Width applies to a data series, and a chart may have more than one series. Depending on the chart type and selection, the setting may affect the selected series or the series group in a way that is visually shared. If the change appears not to affect every bar as expected, select another series and inspect its Series Options as well.

Clustered charts and multiple series

In a clustered bar or column chart, Excel places several series side by side for each category. Imagine a chart comparing sales for three stores across six months: each month has a cluster of three bars. The category cluster has to accommodate all three, so each individual bar may be narrower than a single-series bar even when the overall gap between months is small.

For these charts, check Series Overlap as well as Gap Width in Format Data Series > Series Options. Series Overlap controls how much series bars occupy the same category position. At a low or negative overlap, bars sit side by side; increasing overlap moves them closer together, and 100% makes the series overlap fully. Full overlap can hide a smaller bar behind a larger one, so it is not a general-purpose way to thicken clustered bars.

Use the chart type that matches the comparison:

Choose a clustered chart when readers need to compare separate series within each category.
Choose a stacked chart when the parts of a total matter. The series share one category position, so the result is one thicker stack per category rather than several side-by-side bars.
Consider a single-series chart when the extra series do not add useful information. Removing unnecessary series can give each category more room and simplify the comparison.

Stacking is not a cosmetic fix if readers need to compare individual series across categories: only the bottom series shares a common baseline. Select a stacked chart because its totals and components answer the question, not just because it looks bolder.

When lowering Gap Width is not enough

If a chart has many categories, its plot area must divide available space into many slots. Lowering Gap Width can make each bar wider within its slot, but labels, chart margins, and the overall chart size still impose limits. Try making the chart taller for a horizontal bar chart or wider for a column chart, especially when the chart is embedded in a narrow worksheet cell area or dashboard tile.

To resize a chart, select its outer border and drag a corner handle. A corner drag preserves the general proportions better than pulling only one side. If the chart is on a crowded dashboard, resizing may require moving nearby objects or changing the layout. Do not shrink the plot area by adding oversized titles or legends if the real need is room for the data.

For a long list of categories, consider showing fewer at once. A filter, a focused chart for one region or period, or separate charts for meaningful groups can be clearer than squeezing every category into one graphic. If the purpose is to compare a small number of leading values, sorting the source data and charting the relevant subset may help. Avoid removing data in a way that changes the question the chart is supposed to answer.

Also inspect the category labels. Long labels in a horizontal bar chart can consume chart width, leaving less room for the bars. Shortening labels where it is safe, widening the chart, or moving the chart to a less constrained location may improve the balance. Rotating or shrinking labels can save space, but tiny text is often a worse trade-off than using a larger chart.

Choosing a useful bar thickness

There is no single best Gap Width. A chart for a presentation may need thick bars that remain visible from a distance, while a dense report may need more space between categories so readers can distinguish them. The right setting depends on the number of categories, chart dimensions, series count, and how the chart will be viewed or printed.

A practical way to choose is to start with the current setting and make small changes while watching both the bars and the gaps. For a sparse chart, a value around 50% to 100% can be a reasonable trial range; for a crowded chart, retaining more separation may prevent adjacent categories from blending. These are starting points, not universal standards. Preview the chart at the size readers will actually see, rather than judging it only while zoomed in on a large monitor.

If the bars look like thin lines and categories are clearly separated, reduce Gap Width.
If neighboring bars seem to merge into a solid block, raise Gap Width or increase chart size.
If bars within each category are too narrow, review the number of series and whether a different chart type answers the question better.
If the chart is readable on screen but not in a printed report, check the print preview and page layout; a chart may be scaled down when printed.

Excel for Mac and Excel for the web

In current desktop Excel for Mac, the same basic setting is available through the chart’s Format Data Series pane. Select a series, open its formatting options, and look for Series Options and Gap Width. The pane’s placement and icons can differ from Windows, but the setting has the same purpose. On Mac, Control-click or use a two-finger click if you need the contextual menu; a standard right-click also works when configured.

Excel for the web has chart-formatting tools, but the available controls and pane layout can differ from the Windows desktop app and may change over time. If you cannot find Gap Width in the web interface, open the workbook in desktop Excel and make the adjustment there. The chart’s data does not need to be changed just to alter its spacing.

Frequently Asked Questions

What Gap Width should I use in Excel?
There is no required value. Lower percentages make bars thicker and reduce category gaps; higher percentages leave more separation. Try a few values on the actual chart and choose one that keeps categories distinguishable at the size it will be viewed.

Why are my bars still skinny after I reduce Gap Width?
The chart may contain many categories, multiple clustered series, or too little plot area. Enlarge the chart, reduce the number of displayed categories when appropriate, and review the series count and chart type. Gap Width cannot create space that the chart layout does not have.

Does Gap Width change the values or bar lengths?
No. It changes bar thickness and spacing, not the source data or value-axis scale. If the lengths appear wrong, check the values, category mapping, and axis bounds separately.

How do I make bars thicker without changing the chart size?
Lower Gap Width first. If it is a clustered chart, consider whether all series are necessary, but do not use overlap in a way that hides values. With many categories, there may be a limit to how thick the bars can become while preserving readable category separation.

Can I make only one bar thicker?
Gap Width is a series-level spacing control, not a reliable individual-bar thickness control. Formatting an individual data point can change its fill or border, but it does not provide a separate width setting for that one bar. If one value needs emphasis, use a contrasting fill, label, or annotation instead.

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.