How to Align and Evenly Space Multiple Charts in Excel
Question details
The user wants to align and evenly distribute multiple charts within a spreadsheet to create a neat, professional layout.

- 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.
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.
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.
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.
With the charts selected, go to the 'Chart Format' or 'Shape Format' tab that appears in the top ribbon.
In the Arrange group, click 'Align' and choose an alignment option, such as 'Align Top' or 'Align Left', to snap their edges together.
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.

Snap Charts to the Cell Grid
Use this method when you want your charts to perfectly align with the existing rows and columns of your spreadsheet.
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. Select Charts: Hold 'Ctrl' and click to select all the charts you wish to organize.
- 2. Access Drawing Tools: Navigate to the 'Drawing Tools' tab that appears on the top ribbon when objects are selected.
- 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'.

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.




