Chart & Visualization Issues

How to Align and Evenly Space Multiple Charts in Excel

Aamir Naveed AkramAamir Naveed Akram Oct 10, 2026 873 views

Question details

The user wants to align and evenly distribute multiple charts within a spreadsheet to create a neat, professional layout.

How to Align and Evenly Space Multiple Charts in Excel
Product
Microsoft Excel
Device & OS
Windows, macOS
Scenario
Arranging multiple charts for a presentation or dashboard reporting, where consistent spacing and alignment are required.
Observed behavior
Charts move freely across the spreadsheet and are difficult to align or space perfectly when adjusted manually without grid snapping or alignment tools.
Before you start

Ensure all the charts you want to arrange are placed on the same worksheet, and try to roughly position them in the order you want them aligned before applying distribution tools.

Solution 1Recommended

Use Excel's Built-in Alignment and Distribution Tools

Use this method to quickly align the edges of multiple charts and ensure the spacing between them is perfectly even.

Excel provides built-in Arrange tools under the Format tab. This is the fastest way to tidy up a messy dashboard, as it calculates the exact spacing required between the outermost charts in your selection.

1
Select Multiple Charts

Hold down the Ctrl key (or Cmd on Mac) and click on each chart you want to align. Ensure at least three charts are selected if you want to evenly distribute them.

2
Open the Format Tab

With the charts selected, go to the 'Chart Format' or 'Shape Format' tab that appears in the top ribbon.

3
Align the Charts

In the Arrange group, click 'Align' and choose an alignment option, such as 'Align Top' or 'Align Left', to snap their edges together.

4
Distribute Evenly

Click 'Align' again and select 'Distribute Horizontally' or 'Distribute Vertically'. This will evenly space the charts based on the distance between the first and last chart in your selection.

Use Excel's Built-in Alignment and Distribution Tools
Pro Tip: Before distributing horizontally or vertically, place your first and last charts exactly where you want the sequence to start and end. The tool only moves the charts in between them.
WPS Spreadsheet Feature

Align and Manage Charts Effortlessly with WPS Spreadsheet

WPS Office provides highly compatible and intuitive chart alignment tools, allowing you to create perfectly structured dashboards just like you would in Microsoft Excel.

  1. 1. Select Charts: Hold 'Ctrl' and click to select all the charts you wish to organize.
  2. 2. Access Drawing Tools: Navigate to the 'Drawing Tools' tab that appears on the top ribbon when objects are selected.
  3. 3. Align and Distribute: Click 'Align', choose an edge alignment (like Align Top), and then click 'Align' again to select 'Distribute Horizontally' or 'Distribute Vertically'.
Fully compatible with Microsoft Excel (.xlsx) file formatsOne-click alignment and distribution tools for charts and shapesLightweight, fast, and completely free to useFamiliar user interface requiring zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Align option greyed out in Excel?

The Align and Distribute options are only active when you have selected two or more objects. Ensure you are holding down the Ctrl key (or Cmd on Mac) and clicking on multiple charts to highlight them simultaneously.

Can I lock multiple charts together after aligning them?

Yes. Once you have aligned and evenly spaced your charts, keep them all selected, right-click on the border of one of the charts, and choose 'Group' > 'Group'. This locks their relative positions so you can move or resize them as a single object.

How do I make all my charts the exact same size?

To standardise the size of multiple charts, select all of them by holding Ctrl/Cmd and clicking. Then, go to the 'Shape Format' or 'Format' tab, locate the Size group on the far right of the ribbon, and manually type your desired dimensions into the Height and Width boxes.

Will Snap to Grid work if my gridlines are hidden?

Yes. Even if you have turned off the visibility of gridlines in the View tab for aesthetic reasons, the underlying cell grid still exists, and holding the Alt key will still snap your charts to those invisible cell borders.