In Excel for Microsoft 365 on Windows, change the width of columns in a clustered column chart by selecting a column, opening Format Data Series, and adjusting Gap Width: a smaller percentage makes the columns wider, while a larger percentage makes them narrower. The setting applies to the chart’s category groups, so it does not set a separate pixel width for one individual bar.
How to change the bar width
Use the chart’s formatting pane to adjust the spacing. If the chart contains several series, make sure you select a column belonging to the series you want to format; the Gap Width setting normally affects the spacing across the chart rather than just that one column.
- Select the clustered column chart. If you do not have one yet, select the data and choose Insert > Insert Column or Bar Chart > Clustered Column.
- Click one of the columns once to select the whole data series, rather than clicking a second time to select only one data point.
- Right-click the selected column and choose Format Data Series. The formatting pane opens.
- In Series Options, find Gap Width. Enter a smaller value, such as 75%, to make the columns wider, or a larger value, such as 200%, to make them narrower. Press Enter to apply the value.
- Check the chart at its final size. You may need to resize the chart or revise the percentage if the labels or bars now feel crowded.
On a Mac, select the series and open its formatting pane using the chart’s contextual formatting controls or the right-click menu; the exact pane layout can differ, but the setting is also called Gap Width. Excel for the web may place chart-formatting controls differently from desktop Excel. If a control is not available in your browser version, open the workbook in the desktop app to make the adjustment.
What Gap Width actually controls
A clustered column chart groups columns by category. For example, a chart of quarterly sales might show four adjacent columns for each region, one for each quarter. Gap Width controls the space between one category group and the next, expressed as a percentage related to the width of a data column. It is not a measurement in pixels or a fixed width such as 20 points.
That distinction matters because changing the chart’s size can change the columns’ apparent width even when the Gap Width percentage stays the same. The chart has a finite plot area to divide among its categories. When the plot area gets wider, columns can look wider; when it gets narrower, columns can look cramped. More categories also need more horizontal room. The same percentage can therefore produce different-looking charts in different worksheets or after resizing.
Smaller Gap Width values reduce the space between category groups and make the columns appear wider. Larger values increase the gaps and make the columns look slimmer. A value near 150% is a common starting point in Excel, but defaults and chart appearance can vary with the chart and workbook. Treat the displayed value as a control to tune, not a universal design rule.
Choosing a useful width
Start by deciding what the chart needs to communicate. If the columns are very thin and the chart has only a few categories, reduce Gap Width in small steps. If neighboring groups visually run together, raise it. Try a few values while looking at the whole chart rather than aiming for a particular percentage just because it is common.
- Few categories, few series: A lower gap can make a small number of columns easier to see without making the chart feel sparse.
- Many categories: Keep enough separation for readers to distinguish one category from the next. Very wide columns may crowd together or leave too little room for labels.
- Long category labels: Wider columns do not solve label crowding. Consider making the chart wider, shortening labels where appropriate, or changing the label orientation.
- Presentation or report use: Check the chart at the size at which people will view or print it. A setting that looks balanced on a large monitor may look dense in a narrow report column.
For a practical comparison, duplicate the chart or take note of the current percentage, then compare values such as 100%, 150%, and 200%. These are examples for visual evaluation, not prescribed settings. Keep the version where the groups are distinct and individual columns remain easy to compare.
Why the series count and chart size matter
In a clustered chart, each category group contains one column for every plotted series. If you chart monthly sales for three products, each month has three columns. Those columns share the group’s available horizontal space. Adding more product series makes each column narrower unless the chart is given more room or the spacing is adjusted.
Category count has a similar effect. A chart with 30 months must fit many groups into its plot area, while a chart with four quarters has fewer. If a chart feels crowded, lowering Gap Width can help, but it cannot create more space. Widening the chart, reducing the number of displayed categories, or splitting the information into multiple charts may be more effective.
Also consider the chart’s axes and labels. Rotated or multi-line category labels can take up space beneath the plot area, and a legend may reduce the room available for the columns. Changing the chart layout can affect the visible plot area without changing the Gap Width setting. This is why bar width should be assessed as part of the complete chart rather than as an isolated number.
Gap Width versus Series Overlap
Series Overlap is a different control in the same Series Options area. Gap Width changes the spacing between category groups. Series Overlap changes how the series within each group are positioned relative to one another. In a standard clustered chart, the series are arranged side by side; increasing overlap moves them over one another.
For instance, if Product A and Product B columns are side by side for each month, increasing Series Overlap can make the columns partially cover one another. At full overlap, one series may obscure another unless the series use suitable colors, transparency, or ordering. Reducing the overlap can create more separation between columns within a group. Use this setting only when the intended comparison benefits from that arrangement; it is not the usual first choice for making all columns wider.
If the columns inside a group touch but there is too much space between groups, adjust Gap Width. If the columns in the same group are too close or overlap, inspect Series Overlap as well. Changing one setting does not substitute for the other.
Common problems and how to fix them
- The columns did not change: Confirm that the chart series is selected and that the value was entered in Gap Width, not Series Overlap. Press Enter after typing. If you selected an individual data point, click once on a column to select its full series and reopen the pane.
- The columns became too wide: Increase Gap Width gradually. If category groups still look crowded, widen the chart or show fewer categories rather than forcing the gaps toward zero.
- Only one series seems selected: Excel formats series separately in some chart situations. Check the series name shown in the pane, and select another series if you need to inspect or change its options. Compare the result across the complete chart.
- The chart looks different after copying or resizing: The percentage may be unchanged while the available plot area has changed. Recheck the chart at its new dimensions and adjust the setting if necessary.
- Labels are unreadable: Gap Width only changes column spacing. It does not shorten category names, rotate labels, or create room for a long legend. Address those layout issues separately.
When troubleshooting, make one change at a time. If you are unsure whether a value helped, note the original Gap Width before editing so you can restore it. A chart that looks too dense may be telling you that it contains more categories or series than can be read comfortably at its current size.
When to use another chart approach
Adjusting width is useful when a clustered column chart is otherwise the right way to compare values across categories. It is less useful when there are too many series to compare, when category labels dominate the page, or when the columns are so narrow that differences are hard to see. In those cases, consider a clustered bar chart, which uses horizontal bars and can accommodate long category labels more naturally.
If the main purpose is to compare totals and the parts that make up each total, a stacked column chart may be more appropriate. If the purpose is to compare individual series precisely across many categories, a line chart may be easier to read, provided the data is suitable for a line chart. These alternatives change how readers interpret the data, so choose based on the question the chart needs to answer rather than on width alone.
Frequently Asked Questions
How do I make bars wider in an Excel clustered column chart?
Select a column, open Format Data Series, and lower Gap Width under Series Options. Lower values reduce the gaps between category groups and make the columns appear wider.
What is the default Gap Width in Excel?
A value around 150% is commonly used as a default for column charts, but the displayed value can depend on the chart and workbook. Check the actual value in the chart’s formatting pane instead of assuming every chart starts with the same setting.
Can I set the width of just one bar?
Gap Width is a chart-series spacing control, not a direct width setting for an individual data point. You can format individual points for appearance in some chart types, but that does not provide a dependable independent bar-width measurement. To change the overall look, adjust the chart’s spacing or dimensions.
Why are the columns still narrow after I reduce Gap Width?
The chart may have many categories or many series sharing a limited plot area. Make the chart wider, reduce the number of displayed categories or series, or consider a different chart type. A lower gap cannot overcome the space limits of the chart.
Does Series Overlap change the bar width?
Series Overlap changes how columns from different series line up within each category group. Gap Width controls the spacing between groups. For ordinary side-by-side columns, adjust Gap Width to change the general appearance of column width and use overlap only when you want to change the relationship between series.
Related
- Excel Color Scales: How Conditional Formatting Works
- Close Excel Shortcut Key for Windows and Mac
- Close Group Excel Shortcut: Close Workbooks and Rows
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Combo Chart Example: Build a Clear Two-Axis ChartAn Excel combo chart combines two chart types—such as columns and a line—in one visual. For a practical…
- Excel Pivot Tables: How They Work and When to Use ThemAn Excel PivotTable is a tool for summarizing and exploring a larger list of data without changing the…
- Make a Pivot Wheel Chart in Excel: Steps and OptionsYes. In Excel for Microsoft 365, make a PivotTable, insert a PivotChart, and select a radial style such…
- Creating a Pie Chart in Excel: Steps, Labels, and TipsTo create a pie chart in Excel for Microsoft 365 on Windows, arrange category names beside their values,…
- Excel Pareto Chart Data Labels: Add and Format ThemTo show data labels on a Pareto chart in Excel for Microsoft 365 on Windows, select the chart,…
- Excel Pivot Table: Show All Row ValuesTo show a row label on every line in an Excel PivotTable, select the table, choose PivotTable Design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.