How to Center Bars in an Excel Chart

Charts & pivot tables · Updated November 20, 2026

To center bars within their category spaces in Excel, select the chart’s category axis, open Format Axis, and set Axis position to Between tick marks. If bars in a clustered chart look off-center because several series are plotted together, adjust Series Overlap in the data-series settings as well. These steps apply to Microsoft Excel for Microsoft 365 on Windows.

“Center the bars” can mean different things: positioning bars in category slots, centering series within a cluster, or moving the entire chart object on the worksheet. Start by identifying which one you mean. The guide below covers all three and explains which settings change bar placement versus only changing bar width or spacing.

What You’ll Need

  • An Excel workbook with a chart you can edit. The instructions work with common column and bar charts; some options differ for other chart types.
  • At least one category axis and a chart with data series. If you are working with a shared or protected workbook, make sure you have permission to change the chart.
  • Excel for Microsoft 365 on Windows for the exact ribbon paths below. Excel for Mac has similar formatting controls, while Excel for the web may show a reduced or differently arranged interface.

Step-by-Step

  1. Select the chart and identify the axis. Click once inside the chart so Excel displays the chart selection handles and contextual chart tabs. In a column chart, categories usually appear along the bottom and the value axis runs vertically. In a horizontal bar chart, categories usually appear at the left and values run along the bottom. The category axis is the one to format when the bars seem shifted within their category positions. Click its labels or axis line rather than a bar. If clicking selects the whole chart, click the axis again, or right-click an axis label and choose Format Axis.
  2. Open the category-axis settings. Right-click the category axis and select Format Axis. The Format Axis pane opens, usually on the right. Select Axis Options in that pane; it is represented by a small chart-like icon. Look for Axis position. Depending on the chart type and axis, Excel may offer Between tick marks and On tick marks. If those choices are absent, confirm you selected a category axis and that the chart type supports the setting. A value axis is not the one to change for category placement.
  3. Set the axis position to Between tick marks. Choose Between tick marks to place the category intervals between their boundary tick marks. This is the usual arrangement for column and bar charts: each category has a space, and the bar or cluster is positioned in that space rather than appearing to sit on a boundary. Check the chart after selecting it. The change may be subtle when the chart has many categories or when tick marks are hidden. If the bars now look less balanced, switch back to On tick marks and compare; the most suitable option depends on the chart’s category layout and what its labels represent.
  4. Check whether the chart has multiple series. If each category contains two or more adjacent bars, the issue may be the placement of the series within the cluster, not the category axis. Click one bar once to select the whole series, then right-click and choose Format Data Series. In the Format Data Series pane, open Series Options and find Series Overlap. In a clustered chart, a value near 0% keeps series side by side. A positive value moves them closer together; 100% places them on top of one another. Choose an overlap that matches the intended chart, and check every category to make sure the series remain readable.
  5. Adjust the cluster’s spacing only if needed. In the same Format Data Series pane, find Gap Width. A smaller percentage makes bars wider and reduces the space between category clusters; a larger percentage makes bars narrower and adds more space. This setting affects the visual weight and spacing of the chart, not the axis position or the mathematical center of each category. Change it in small increments and judge the result at the chart’s intended display size. If a single bar appears narrow, changing Gap Width may help it look more prominent, but it will not correct a misplaced category axis.
  6. Review category order and empty categories. Look for blank rows, filtered categories, or labels that do not have values. A category with no visible bar can make the remaining bars seem off-center even when Excel has positioned them correctly. Check the source data by selecting the chart and choosing Chart Design > Select Data. In the Select Data Source dialog, confirm that the chart data range includes the intended labels and values, and that categories and series are arranged as expected. If you intentionally need an empty category, keep it; otherwise, remove the blank row from the chart’s source range.
  7. Center the chart object if that is what you meant. Axis settings move bars inside the plot area; they do not center the whole chart on the worksheet. To center the chart object on a worksheet, select its outer border and use Shape Format > Align, then choose the relevant alignment option. For precise placement relative to cells, drag the chart by its border and use the worksheet grid as a guide. If you need it centered on a printed page, open Page Layout > Margins > Custom Margins and use the centering options for the page. These actions reposition the chart itself, not its bars inside the plot area.

On Excel for Mac, select the axis or series and use the contextual menu to open its formatting pane; the same concepts, including axis position, overlap, and gap width, are available in current desktop versions, although the pane layout and ribbon labels can vary slightly. In Excel for the web, try selecting the axis or series and opening its formatting options. If a setting is missing, open the workbook in the desktop app to use the full chart controls.

Common Mistakes

  • Formatting the value axis instead of the category axis. The value axis controls the numeric scale, such as 0 to 100. It usually does not determine which category slot a bar occupies. Select the axis containing category names or dates before changing Axis position.
  • Expecting Gap Width to move the center. Gap Width changes bar thickness and space between category clusters. It can make a chart feel more balanced, but it does not shift bars from one category position to another.
  • Setting Series Overlap to 100% when you want side-by-side bars. At full overlap, series cover one another, so a bar may appear missing. Use 0% for a typical side-by-side cluster, or a negative overlap if you want more separation and the chart supports that value.
  • Changing the chart type without checking the data. A stacked chart, clustered chart, and single-series chart place bars differently. If the result is confusing, use Chart Design > Change Chart Type to verify that the chart type matches the comparison you want to show. Changing types can alter how series are grouped.
  • Judging alignment from a cropped screenshot. The plot area may be offset by a long axis label, chart title, or legend. That can make bars appear off-center relative to the chart’s outer border even though they are centered in their category slots.

Tips

  • Make one change at a time: first Axis position, then Series Overlap, then Gap Width. This makes it easier to tell which setting helped.
  • Use the plot area, not the chart’s outer edge, as the reference when judging bar placement. The title, legend, and labels take up space around the plot area.
  • For a chart with one series, start with the default overlap and adjust Gap Width only for readability. Overlap is most useful when categories contain multiple series.
  • Keep category labels and data in a continuous, clearly structured range. Extra blank rows in the source data can create empty slots that look like alignment problems.
  • Resize the chart to approximately its final on-screen or printed size before fine-tuning. Bars that look centered when the chart is large may look crowded when it is reduced.
  • If the axis includes dates, check whether Excel is treating it as a date axis or a text category axis. Date axes use a continuous timeline, so the spacing reflects time intervals rather than equal-width category slots.

Troubleshooting

The Axis position options do not appear. You may have selected the value axis, a data label, or the chart area. Click a category label, such as a name beneath a column or beside a horizontal bar, then reopen Format Axis. If Excel still does not show the option, check the chart type; not every chart or axis exposes the same controls.

The bars still look off-center after changing the axis. Check for empty categories, uneven date intervals, or a legend and title that make the plot area look visually offset. Click the plot area and compare its left and right boundaries. If only some categories look unusual, inspect the corresponding cells in the chart’s source range for blanks, text in numeric cells, or missing values. Also confirm that the category labels are assigned to the correct data points in Chart Design > Select Data.

Series overlap makes bars disappear. Reopen Format Data Series > Series Options and reduce Series Overlap toward 0% for clustered bars. If the chart is stacked, overlap is part of how the chart is drawn, so switching to a clustered chart may be necessary to display bars side by side. Check that each intended series has a distinct name and values in the source data.

The bars are centered, but the entire chart is not. Select the chart border rather than a bar or axis. Then reposition or align the chart object. If the problem occurs only in print preview, adjust page margins and page-centering settings; changing bar settings will not center a printed chart on the page.

The chart looks different on another computer or in the browser. Fonts, window size, and Excel’s available chart controls can affect the appearance. Confirm the workbook in the desktop version and check the same axis and series settings there. Avoid relying on small visual differences in a compressed view; compare the chart at a consistent size.

Frequently Asked Questions

Are Excel chart bars centered by default?
In standard column and bar charts, bars are normally positioned within their category slots by default. If they look shifted, check axis position, series grouping, blank categories, and the plot-area layout before changing several settings.

Should I choose Between tick marks or On tick marks?
Start with Between tick marks for the usual category-slot layout. Compare it with On tick marks if the labels or category meaning make the alternative clearer. The right choice is the one that places the categories and bars where readers can interpret them accurately.

Does Gap Width center bars?
No. Gap Width controls bar width and the empty space between category clusters. Use Axis position for category placement and Series Overlap for the relative placement of multiple series.

How do I center two bars in each category?
Use a clustered column or clustered bar chart, then select a series and adjust Format Data Series > Series Options > Series Overlap. Around 0% is a sensible starting point for two side-by-side bars. If the cluster seems too loose, reduce Gap Width slightly.

Can I center bars in Excel for the web?
You can edit many chart properties in Excel for the web, but the available controls may differ from desktop Excel. If you cannot find Axis position or Series Overlap, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the adjustment there.

How do I center the chart on a worksheet or printed page?
That is different from centering bars within categories. Select the chart border to move or align the object on the sheet. For printing, use the page-centering choices in Page Layout > Margins > Custom Margins.

Related

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.