To make bars wider in an Excel stacked bar chart, select a bar, open Format Data Series, and reduce Gap Width under Series Options. A smaller gap makes each horizontal bar thicker; it does not change the values or the relative sizes of the stacked segments.
How bar width works in a stacked chart
In an Excel bar chart, categories are listed vertically and the bars extend horizontally. In a stacked bar chart, each category has one bar made up of adjoining segments, with each segment representing a series. In this orientation, making a bar wider means increasing its height on the screen. This differs from a stacked column chart, where the bars extend upward and “wider” means increasing their horizontal thickness.
The main control is Gap Width. It sets the space between category bars relative to the thickness of a bar. Lowering the percentage reduces the gaps and gives the bars more of the available chart space. Raising it creates more separation and thinner bars. The setting affects the chart’s category bars, not the length of an individual segment, which is determined by its data value and the axis scale.
For example, if a chart has a Gap Width of 150%, changing it to 70% will generally make its bars look substantially thicker. The exact visual change depends on the chart’s size and number of categories. A setting of 0% removes the category gaps, but that can make adjacent bars look like one continuous block, so it is not always the clearest choice.
Steps to reduce Gap Width in Excel for Windows
These steps apply to a standard 2-D stacked bar chart in Excel for Microsoft 365 on Windows:
- Click the chart, then click one of the colored segments in a bar. If needed, click again until a data series is selected. The whole series should be highlighted, not just the chart area.
- Right-click the selected segment and choose Format Data Series. The formatting pane opens on the right. You can also select the series and press Ctrl+1 to open its formatting pane.
- In the pane, choose Series Options, then find Gap Width.
- Enter a smaller percentage or move the slider to the left. Try 75% or 50% as a starting point, then adjust while looking at the chart.
- Click outside the pane when the bars have the thickness and spacing you want. The change is applied to the chart as you format it.
For a stacked chart, the series form one stack for each category. If the chart contains several stacked series, changing Gap Width changes the category-bar spacing for that chart group; it does not independently thicken just one colored segment. On a Mac, select a segment and open Format Data Series from its context menu; the pane has the same Gap Width control, though the ribbon and pane layout can vary slightly. Excel for the web also offers chart formatting, but if the control is missing for a particular chart, open the workbook in the desktop app.
Choosing a useful Gap Width setting
There is no universally correct percentage. The best setting depends on how many categories the chart shows, the chart’s dimensions, and whether readers need to distinguish one category from the next. Start by making a moderate change rather than immediately setting the gap to zero.
- About 100%: A practical starting point when the default bars look too thin but category separation still matters.
- About 50% to 75%: Often useful when there are many categories or the chart is displayed at a small size. Check that neighboring bars remain visually distinct.
- 0%: Bars touch with no gap. Consider this only when a continuous appearance is appropriate and category boundaries remain clear from labels or other cues.
- Above 100%: Useful when a chart feels crowded and you want more space between categories, although the bars will look thinner.
These are starting points, not fixed rules. A chart with four categories may look balanced at a different setting from one with twenty. Review the chart at the size readers will actually see it, such as on a report page or in a presentation, rather than judging only from a zoomed-in editing view.
When resizing the chart works better
Gap Width changes the relationship between bar thickness and the gaps, but it cannot create more room in a chart that is physically too small. If the bars remain cramped after lowering the gap, increase the chart’s height. Because categories in a bar chart are arranged from top to bottom, more vertical space gives each category more room. Drag a corner sizing handle to enlarge the chart, or use the chart’s size controls on the ribbon when you need precise dimensions.
Also consider how many categories are being displayed. A chart with 30 categories will give each bar less vertical space than a chart with six categories of the same height. If all categories are not essential, show a useful subset, split the data across more than one chart, or provide a larger chart area. Avoid shrinking text or removing labels merely to make the bars appear thicker; readers still need to identify what each bar represents.
Chart elements use some of the available space. A long title, a legend, or extensive axis labels can reduce the area available for the plotted data. In a horizontal bar chart, the legend may sit below or beside the plot, while category labels occupy space on the left. Moving or simplifying nonessential elements can make the plot easier to read, although increasing chart height is usually the direct fix for bars that are too short.
What to check if the bars do not change
If adjusting Gap Width seems to have no effect, first confirm that you selected a data series rather than the chart area, an axis, or a single chart element. The pane title should say Format Data Series. If it says Format Chart Area or Format Axis, close the pane, select a colored bar segment, and reopen the series options.
Then check the chart type. A stacked bar chart and a stacked column chart both use stacked segments, but their bar orientation differs. In a column chart, the category bars run vertically, so the relevant visual thickness is horizontal. The same gap-width idea applies, but the chart needs horizontal room to make those columns wider. Some 3-D chart types and unusual combination charts expose different formatting controls, so use a standard 2-D stacked chart if you need the familiar Gap Width setting.
Finally, check whether the chart is a separate chart group in a combination chart. A chart that combines different chart types or uses a secondary axis can have more than one group of series, with formatting options applying to the selected group. Select a segment belonging to the stacked bar group and confirm the change on the bars you intend to format. If the issue is that segment lengths seem wrong, Gap Width is not the relevant setting: review the source values, axis bounds, and whether the chart is stacked or 100% stacked.
Gap Width is not Series Overlap
These two settings are easy to confuse. Gap Width controls the space between category bars. Series Overlap controls how series sit in relation to one another in chart types where series can be clustered or overlaid. In a stacked bar chart, the series are already arranged end to end within each category’s bar. Changing overlap is not the usual way to make the complete bars thicker.
Likewise, a wide-looking stack is not necessarily a more accurate one. Gap Width changes presentation only; it does not alter the underlying data, the segment order, or the totals. If you want to change the length of a segment, check the value in the worksheet or the horizontal value axis. If you want more thickness for every category, adjust Gap Width or the chart’s height.
Stacked bar, 100% stacked, or stacked column?
Choose the chart type for the comparison you want to communicate before fine-tuning its appearance. A regular stacked bar chart shows both the total for each category and the contributions of the component series. A 100% stacked bar chart scales every category to the same total length, making it easier to compare proportions but harder to compare absolute totals. Both can use Gap Width to adjust the thickness and spacing of their category bars.
A stacked column chart presents the same general kind of composition vertically. It can be appropriate when categories belong along a horizontal sequence, such as months, but numerous categories can make labels crowded. Switching from bar to column does not automatically make the bars wider; it changes their orientation and the direction in which chart space is needed. If category names are long, a horizontal stacked bar chart may be easier to label.
For example, suppose a chart shows three product types across eight regions. A regular stacked bar chart can compare total units by region while showing the product mix. Reducing Gap Width makes the eight region bars thicker, but it does not make the product segments easier to compare when their colors are similar. A clear legend, distinct colors, and sensible category order matter too.
Keep thicker bars readable
Thicker bars can improve legibility, especially when the chart will be printed or viewed in a small space, but filling every gap may make categories run together. Use enough separation for the eye to track each bar, and keep category labels aligned with the correct stacks. If you use data labels, check that they do not overlap when bars become thicker or when segment values are small.
For a clean result, make one adjustment at a time: lower Gap Width, inspect the chart at its intended display size, and then resize the chart if necessary. If the chart feels crowded, reconsider its category count or legend placement rather than relying on extreme formatting. Consistent spacing and readable labels are generally more useful than making every bar as large as possible.
Frequently Asked Questions
What Gap Width should I use for a stacked bar chart?
There is no single best value. Try 75% or 50% if the default bars are too thin, then check that categories remain distinct at the final chart size.
Can I make only one segment in a stacked bar thicker?
No. The segments in one stack share the bar’s thickness. Gap Width changes the thickness of category bars, not the size of one series segment by itself.
Does reducing Gap Width change my data?
No. It changes chart spacing and appearance only. It does not change worksheet values, totals, segment lengths, or the chart’s underlying data.
Why are my stacked bars still thin at 0% Gap Width?
There may be too little chart height for the number of categories. Enlarge the chart vertically, reduce the number of categories shown, or use a larger chart area.
How do I make stacked columns wider instead?
Select a column series, open Format Data Series, and reduce Gap Width. For a column chart, make sure the chart has enough horizontal space for the wider columns.
Related
- Excel Redo Shortcut: Repeat Your Last Action on Windows
- Excel Shortcut to Select Every Cell in a Column on Windows
- Excel Shortcut for Lowercase Text: What Actually Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Power Pivot Slicers: How to Add and Connect ThemA Power Pivot slicer is a clickable filter for a PivotTable built from Excel’s Data Model. In Excel…
- Graph y = -2: Plotting the Horizontal Line Step by StepIf you mean the equation y = -2, graph it as a horizontal line two units below the…
- Add a Zero Line to an Excel Chart: Methods and TipsTo add a zero line to an Excel chart, either make the value axis cross at 0 or…
- Excel Chart Types: Uses, Examples, and How to ChooseExcel includes chart types for comparing categories, showing change over time, displaying parts of a whole, and exploring…
- Steps Progress Chart in Excel: Build a Clear TrackerTo create a steps progress chart in Excel, list each step and its completion percentage, calculate the remaining…
- Excel Waterfall Chart Example: Build One Step by StepAn Excel waterfall chart shows how a starting value changes through a series of increases and decreases to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.