To center a bar graph in Excel, first decide whether you mean the whole chart object or the bars inside its plot area. For the chart object, drag it into position on the worksheet or align it with other charts; for a printed page, use the page-centering settings. Bars within a standard chart are normally centered on their categories automatically, so changing the chart layout or axis settings is usually the right fix if those bars look off-center.
The instructions below are for Excel for Microsoft 365 on Windows. Excel for Mac has similar chart and page-layout options, although ribbon placement can differ. Excel for the web supports basic chart resizing and moving, but some alignment and print-layout controls may be limited.
What You’ll Need
- An Excel workbook with a bar or column chart, or data ready to chart. In Excel, a bar chart has horizontal bars; a column chart has vertical bars.
- A clear idea of what you want centered: the chart on a worksheet, several charts relative to one another, the chart on a printed page, or the bars within the plot area.
- If you are positioning a chart on a worksheet, use visible row and column boundaries as guides. Turning on gridlines can make it easier to judge the chart’s location.
Step-by-Step
- Identify what needs to move. Click the outside edge of the chart. If a border and sizing handles appear around the whole chart, you have selected the chart object. Dragging this object moves the chart and all of its contents together. If only the inner plotting region or an individual bar is selected, press Esc and click the outer border instead. If the chart frame is already centered but the bars look misplaced inside it, leave the chart where it is and go to step 6.
- Make sure the chart has a useful reference area. Decide what it should be centered within: the visible worksheet, a particular group of cells, or a printed page. For a chart beside data, you may want it centered over the columns containing the data rather than the entire worksheet. If needed, show worksheet gridlines using View > Gridlines. Gridlines are visual guides; they do not print unless you enable gridline printing in Page Layout.
- Move the chart on the worksheet. Point to the chart’s outer border until the pointer changes to a move pointer, then drag the chart. To center it over a region of cells, compare the empty space from the chart’s left edge to the region’s left edge with the space from its right edge to the region’s right edge. Adjust the chart until those margins look equal. Use the row and column boundaries as reference points, and zoom in if small adjustments are difficult.
- Resize before making the final placement. If the chart is too wide or tall for the area, drag a corner sizing handle inward or outward, then reposition it. Resizing changes the chart’s overall frame, including its title, legend, and plot area. Avoid dragging a handle on just one side if you want to preserve the chart’s proportions; corner handles are generally easier to control. Once the chart is the right size, check the margins again because resizing changes its center point.
- Align multiple charts with each other. If you have two or more charts, Ctrl-click each chart’s outer border to select them together. Open the contextual Format tab and choose Align > Align Center to line up their horizontal centers, or Align > Align Middle to line up their vertical centers. These commands align the selected objects relative to one another; they do not automatically center a single chart on the worksheet. Click a blank cell when you are done to clear the selection. On Mac, use Command-click to add charts to the selection; ribbon labels may be arranged differently.
- Center a chart on a printed page. If you want a chart centered for printing rather than centered among worksheet cells, put it on its own chart sheet. Select the chart, then choose Chart Design > Move Chart > New sheet and confirm. On the new chart sheet, open Page Layout > Margins > Custom Margins. Under Center on page, select Horizontally, Vertically, or both, then choose OK. Use File > Print to preview the result. These page settings affect print placement; they do not reposition the chart on the original worksheet.
- Check bar alignment inside the plot area. Click a bar once to select its data series, or click the category axis to select the axis. In a column chart, categories are normally placed between tick marks, which centers each category’s bar or cluster in its category space. To inspect this setting, right-click the category axis, choose Format Axis, and look under Axis Options for Axis position. Choose Between tick marks for the usual centered-category arrangement. On a horizontal bar chart, the category axis runs vertically, so select that axis rather than the horizontal value axis.
- Adjust spacing without confusing it with centering. To change the gaps between bars, right-click a bar and choose Format Data Series. Under Series Options, adjust Gap Width. In a clustered chart, Series Overlap changes how series within each category sit relative to one another. These settings change bar spacing or overlap; they do not move the chart object or center the entire group of categories on the worksheet. Check the chart after each change so the bars remain easy to compare.
Common Mistakes
Centering the wrong thing. A chart object can be centered on the sheet while its bars look uneven inside the plot area, or the bars can be centered by category while the chart sits off to one side. Select the chart border when moving the whole chart. Select an axis or data series when adjusting the internal layout.
Expecting Align Center to center a single chart on the worksheet. In Excel, Align Center is useful for lining up multiple selected objects. It is not a general center-on-sheet command for one chart. For one chart, position it against worksheet boundaries by eye, use cell edges as guides, or center it for printing with the page setup options.
Changing Gap Width to fix chart placement. Gap Width affects the distance between bars, not the chart’s position. If the whole chart is too far left or right, move the chart. If the plot area looks too narrow inside the chart frame, select and resize the plot area rather than changing bar spacing.
Using the wrong axis. The value axis controls the numeric scale, while the category axis lists the labels. In a horizontal bar chart those axes are arranged differently than in a column chart. Selecting the wrong one can change the scale or label behavior without correcting the apparent alignment.
Forgetting that printing and worksheet layout are separate. A chart can look centered on screen but print off-center because of margins, paper size, scaling, or other content on the sheet. Conversely, a print-centering option does not move the chart object on the worksheet. Use Print Preview to verify the printed page.
Tips
Make the chart’s intended area clear before you start. If the chart should sit above a table, use the table’s left and right edges as the centering boundaries. If it should sit beside data, center it within the columns or cells reserved for the chart. Equal visible margins are a more reliable visual check than guessing from the worksheet’s overall width, especially when only part of the sheet is in use.
For a more controlled layout, arrange the worksheet into a simple grid. Reserve a block of cells for each chart, keep the chart edges close to cell boundaries, and leave consistent gaps between blocks. On Windows, holding Alt while dragging or resizing an object can help it snap to cell boundaries in desktop Excel. If that behavior is unavailable or inconvenient in your Excel version, use the grid as a visual guide and inspect the result at a higher zoom level.
When you have several charts, set their sizes first and then align them. Align Center gives them a shared horizontal center; Align Middle gives them a shared vertical center. If the charts should form a row, compare their top edges as well. A chart with a long title or a large legend may have a different-looking plot area even when the chart frames align, so compare the outer borders for object alignment and the plot areas for visual consistency.
Keep the chart’s title and legend in mind. A centered chart frame does not guarantee that the plotted bars appear visually centered if a legend takes up space on one side or the title is much wider than the plot. If the graph seems unbalanced, try moving the legend, shortening the title, or resizing the plot area. First make a small change and review the result; changing several layout settings at once makes it harder to identify what helped.
For a printed chart, select the paper size and orientation before fine-tuning margins. A wide chart may fit better in landscape orientation. Use File > Print to check the page preview after changing settings, and confirm that the chart is not clipped or reduced so much that labels become hard to read. If the chart is part of a worksheet with other content, check the full printed sheet rather than assuming the chart-sheet centering option applies.
Troubleshooting
The chart will not move. Click its outer border, not a bar, title, or axis. If the sheet is protected, the chart may be locked from editing; review the sheet protection settings or ask the workbook owner before changing them. In Excel for the web, try selecting the chart frame and dragging a border or corner. If the chart is embedded over cells, make sure you are not trying to move it by dragging a worksheet cell.
The charts move, but they do not line up. Confirm that each chart is selected by its frame and that all intended charts are selected. Then use Format > Align > Align Center or Align Middle. If one chart is much larger, the command aligns the centers of the chart objects, not their top edges or plot areas. To line up top edges, use Align Top where available, or adjust the objects manually after centering.
The bars still look off-center after changing Axis position. Check whether the chart is clustered, stacked, or contains more than one series. Several series intentionally occupy a category group together, so one series may sit to the left or right of the category’s midpoint. Review Series Overlap and Gap Width under Format Data Series, and confirm that categories and series are arranged as intended in the source data. Do not change the value-axis scale just to shift a bar group.
The chart is centered on screen but not on paper. Open Print Preview and check the page orientation, margins, scaling, and print area. For a chart that needs its own centered page, move it to a chart sheet and enable Center on page in Custom Margins. For a worksheet printout, check the worksheet’s page setup rather than relying on the chart’s on-screen location.
The Align command is missing or unavailable. Select the chart frame and look for the contextual Format tab. Align options may be disabled when only one object is selected or when the selection includes something that cannot be aligned as an object. In Excel for the web or on Mac, the controls can appear in a different location or be more limited; use the desktop Windows version if you need the full set of object-arrangement options.
Frequently Asked Questions
Are bars automatically centered in an Excel bar chart?
Usually, yes. Excel positions each category’s bar or group of bars in its category space. If the chart looks off-center, check the selected axis, the chart’s plot area, series arrangement, and any legend before changing the chart’s position.
How do I center a chart between two columns?
Resize the chart to fit the space, then drag it until the left and right margins between the chart frame and the two column boundaries look equal. Use gridlines and zoom in to refine the placement. Align Center is intended to align multiple selected objects, not to center one chart between worksheet columns.
Can I center a chart horizontally and vertically on a printed page?
Yes. Move the chart to its own chart sheet, then choose Page Layout > Margins > Custom Margins and select both Horizontally and Vertically under Center on page. Check File > Print to confirm the page preview.
What is the difference between a bar chart and a column chart?
A bar chart displays bars horizontally, while a column chart displays them vertically. The same general chart-object positioning steps apply to both, but the category and value axes appear in different directions.
Why does Align Center not move my chart to the middle of the worksheet?
That command aligns selected objects with one another. With only one chart selected, it does not calculate the center of the worksheet. Position a single chart using cell boundaries, or use page-centering settings if your goal is to center it in print.
Does changing Gap Width center the bars?
No. Gap Width changes the space between bars, while Series Overlap changes the placement of multiple series within a category. Use those settings to adjust spacing, not to center the chart frame on the worksheet.
Related
- Add a Drop-Down in Excel and Color Its Selected Cells
- Add a Border to an Image in Excel: Step-by-Step
- Add Color to Excel Data Validation Lists
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Subtotals: How to Show, Change, and Fix ThemIn Excel for Microsoft 365 on Windows, select a cell in the PivotTable and choose PivotTable Design >…
- Stacked Waterfall Chart in Excel: Handling NegativesExcel’s built-in Waterfall chart can show positive and negative changes, including a running balance that falls below zero,…
- Gantt Chart Excel Template for Construction ProjectsA construction Gantt chart Excel template is a task list linked to a calendar grid, with colored bars…
- Excel Chart in PowerPoint: How to Copy and Link ItTo put an Excel chart in PowerPoint, select the chart in Excel, copy it, then use PowerPoint’s paste…
- Excel Area Chart: How to Create and Format OneTo create an area chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert…
- Butterfly Graph in Excel: How to Build and Format OneTo make a butterfly graph in Excel, put one comparison series in negative values and the other in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.