To make columns wider or narrower in an Excel chart, select a chart column, open Format Data Series, choose Series Options, and change Gap Width: a smaller percentage makes columns wider, while a larger percentage makes them narrower. If you mean the worksheet’s lettered columns instead, use Home > Format > Column Width; chart columns and worksheet columns are separate settings.
Chart column width and worksheet column width are different
The word column can refer to two unrelated things in Excel. A worksheet column is a vertical group of cells identified by a letter, such as column A or B. Its width controls how much space those cells have for displaying values and text. A chart column is a vertical bar in a column chart. Its apparent width is controlled mainly by chart formatting and the space available in the chart.
Changing a worksheet column’s width does not directly set the width of columns in a chart. Likewise, changing a chart’s Gap Width will not resize the cells in the worksheet. First decide which object looks too narrow or too wide. If the issue is crowded labels or data in cells, change the worksheet width. If the plotted bars look too thin or too thick, change the chart’s Gap Width.
How to change column width in an Excel chart
These steps apply to a standard two-dimensional column chart in Excel for Microsoft 365 on Windows. The setting belongs to a data series, so make sure you select one of the chart’s columns rather than the chart area, plot area, or a single text label.
- Click the chart, then click one of the columns in the series you want to format. Clicking a column once normally selects the whole series. If only one individual data point is selected, click the series again or use the chart element selection controls to select the series.
- Right-click the selected series and choose Format Data Series. Excel opens the formatting pane.
- In the pane, open Series Options and find Gap Width.
- Enter a smaller percentage to make the columns wider, or a larger percentage to make them narrower. Press Enter or click elsewhere to apply the change.
For example, if the columns look too thin, try reducing the current Gap Width value in steps, such as from 150% to 100%, and assess the result. If the columns then look crowded, raise the value slightly. The best setting depends on the chart’s size, number of categories, and number of series, so there is no single ideal percentage for every chart.
In Excel for Mac, select the chart series and open Format Data Series from its contextual menu or the chart-formatting controls, then adjust Gap Width under Series Options. Excel for the web has chart-formatting controls too, but the available controls and their placement can differ from the desktop apps. If you cannot find the setting in the web interface, open the workbook in the Excel desktop app.
What Gap Width means
Gap Width is a relative spacing setting, not a direct measurement in pixels, points, or inches. It describes the space between category groups in relation to the width of a column. In general, a lower Gap Width value leaves less space between groups and makes the columns appear broader; a higher value leaves more space and makes them appear thinner.
This is why entering a Gap Width value does not guarantee a particular physical column width. The chart has to divide its plot area among the categories and series. A chart with 5 categories has more horizontal room per category than a chart of the same size with 30 categories. Making the chart itself wider can also give each category more room, even if the Gap Width setting stays unchanged.
For a chart with several data series, Gap Width affects the spacing between category groups, while Series Overlap, when available, affects how the series are positioned relative to one another. In a clustered column chart, the series usually sit side by side within each category. Adjusting overlap can make those columns touch or overlap, but it is not a substitute for adjusting the gap between category groups.
Choosing a useful width for your chart
Choose a setting based on readability rather than trying to make every column as wide as possible. Wider columns can make small charts easier to scan, but if they nearly touch, the gaps that distinguish categories disappear. Narrower columns can make a crowded chart less solid-looking, although very thin bars are harder to compare.
- Few categories: A chart with only a handful of categories may look sparse with a large gap. Reduce Gap Width until the columns use the available area without merging visually.
- Many categories: With dozens of categories, narrow columns may be unavoidable. Consider increasing the chart’s width, filtering the displayed categories, or using a different chart presentation rather than forcing the bars to fill the plot area.
- Multiple series: In a clustered chart, each category contains several columns. Check that the individual series remain distinguishable and that category groups are still separated.
- Labels or small values: If labels overlap, changing bar width alone may not fix the problem. Reduce the amount of displayed labeling, enlarge the chart, or adjust the axis-label presentation.
It can help to compare the chart at the size people will actually see it. A chart that looks clear while selected and enlarged may be difficult to read when placed in a report, printed, or viewed on a small screen.
How chart type affects the setting
Gap Width is most relevant to column and bar charts, where the data is drawn as rectangular bars. A clustered column chart is often the clearest choice when the goal is to compare several series side by side. A stacked column chart instead emphasizes totals and how each series contributes to them; making its columns wider does not change the meaning of the stacked segments.
A line chart does not have column bars to resize, and changing Gap Width is not the right way to modify it. If the chart uses a different type, first confirm that you are working with a column or bar chart and that the selected object is a data series. For a chart with a secondary axis or unusual formatting, the available series options can depend on the chart configuration.
Changing the chart type may be a better solution than repeatedly adjusting width. For example, many categories with long names can be easier to read in a bar chart, where the bars run horizontally and labels can appear along the vertical axis. A line chart may be more appropriate for showing a trend across ordered time periods. Width changes improve presentation, but they do not resolve a mismatch between chart type and the question the data should answer.
Adjusting worksheet column width instead
To change the width of cells in the worksheet in Excel for Microsoft 365 on Windows, select one or more column headings, then choose Home > Format > Column Width. Enter a number and confirm. The width value is based on character units related to the default font, rather than a simple number of pixels, so the same setting should not be interpreted as an exact physical measurement in every display situation.
You can also drag the boundary between two column headings. Dragging the boundary to the right widens the column; dragging it left narrows it. To fit the longest visible entry automatically, select the column and choose Home > Format > AutoFit Column Width. Double-clicking the boundary on the right side of a selected column heading also commonly autofits that column.
On Mac and in Excel for the web, the ribbon layout and menu presentation can differ, but look for the column-width or autofit commands in the Home formatting controls. If the heading is hidden because columns are grouped or the sheet is scrolled, locate the relevant column first. You can select multiple column headings to apply the same numeric width to all of them.
Common problems and how to fix them
- The whole chart is selected instead of the bars: Click a bar inside the plot area, not the chart border. Then right-click and check whether Excel offers Format Data Series. If it offers formatting for the chart area, you selected the wrong object.
- Only one bar changes or is selected: You may have selected a single data point rather than the full series. Select the series before changing its options. The exact selection behavior can take more than one click because Excel distinguishes a data point from its series.
- The columns still look thin after reducing Gap Width: The plot area may be too small, or there may be many categories or series. Enlarge the chart or plot area, reduce the displayed categories, or review whether a different chart type would be clearer.
- Columns look crowded after making them wider: Increase Gap Width, enlarge the chart, or reduce the number of categories shown at once. In clustered charts, also check whether series overlap is contributing to the crowded appearance.
- Worksheet text is still cut off: Chart Gap Width does not affect cell contents. Select the worksheet column and use AutoFit Column Width, or set a wider column directly.
Another frequent misconception is that there is a fixed column-width setting for every chart, like a cell width measured in character units. There is not. For a chart, the visible bar width emerges from the plot area, category count, series arrangement, and Gap Width. If a precise visual result matters, adjust those factors together and review the chart at its final size.
Resizing a chart and keeping the result readable
Resizing the chart changes the size of its plot area and can therefore change how wide the columns appear on screen. To resize, select the chart and drag one of its sizing handles. Keep the proportions sensible: making a chart very wide but short can compress vertical comparisons, while making it very narrow can leave insufficient room for category labels.
After resizing, check the axis labels, legend, and data labels as well as the bars. A width setting that looked good before resizing may no longer be appropriate because the chart now allocates space differently. If you copy the chart into another document or place it in a differently sized area, inspect it there too. The chart’s formatting remains a chart setting, but its appearance depends on the space in which it is displayed.
Frequently Asked Questions
How do I make columns thicker in an Excel chart?
Right-click a chart series, select Format Data Series, open Series Options, and lower Gap Width. The columns become broader relative to the gaps, though the result also depends on chart size and category count.
Can I set an Excel chart column to an exact pixel width?
Not with the standard Gap Width control. It uses a relative percentage, and the final on-screen width depends on the plot area and number of categories and series. Adjust the chart size and gap setting together to get the desired appearance.
Why does changing column width in the worksheet not change my chart?
Worksheet column width applies to cells, not to plotted bars. To alter chart columns, change Gap Width in the data-series formatting pane. To show more cell content, change the worksheet column width separately.
How do I make Excel columns fit their contents automatically?
Select the worksheet column or columns and choose Home > Format > AutoFit Column Width. This changes cell-column widths; it does not change chart-bar widths.
Why are the columns still narrow when Gap Width is low?
A small plot area, many categories, or several series can limit the space available to each bar. Enlarge the chart, simplify the displayed data, or consider a chart type better suited to the comparison.
Related
- Excel Lagging and Not Responding? Causes and Fixes
- Excel PivotTable Tips for Clearer Reports
- Excel Not Responding and Unsaved? Recover Your Work
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Sort a Column Chart by Value: Step-by-Step GuideTo sort an Excel column chart by value, sort the chart’s source data: select the whole data range,…
- Excel Waterfall Combo Charts: Setup and WorkaroundsYes—but Excel’s built-in Waterfall chart cannot be combined directly with another chart type in the standard Combo chart…
- Excel Custom Combo Chart: How to Build and Format OneAn Excel custom combo chart combines two or more chart types—such as columns and a line—in one chart,…
- Clustered Column Line Chart in Excel: How to Make OneIn Excel, a clustered column line chart is a combo chart: it displays one or more data series…
- Excel Graph: How to Switch the X and Y Axes in a ChartTo switch the X and Y values in an Excel chart, use an XY (Scatter) chart, then go…
- Excel Histogram Function: Charts, Bins, and FREQUENCYExcel does not have a worksheet function named HISTOGRAM. To make a histogram in Microsoft 365 for Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.