Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how to quickly layout your charts in a panel chart or shape grid with a VBA macro in Excel. Download the Excel file: https://www.excelcampus.com/vba/panel-charts-shape-grid-macro/

Aligning and distributing shapes for a dashboard report can be a time consuming task in Excel. In this video I share a set of macros that allows you to organize shapes (charts, slicers, images, etc.) in a horizontal or vertical layout.

You can specify the number of rows or columns in the grid, and also the gap width between each shape. The macro creates a grid of shapes on the sheet, with an even space between each shape.

Other videos in this series:

(Part 1) 2 Ways to Align & Distribute Shapes in Excel + VBA Macro: https://youtu.be/TU65nEnh7yE

(Part 3) How to Layout Panel Charts or Shape Grids with a VBA Macro in Excel: https://youtu.be/8C1sCqLE1-c


Links mentioned in the video:

Video Playlist for Personal Macro Workbook video series: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

3-Part Video Series on Pivot Tables & Dashboards: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_9EZ_aOZiFJY1DbASEsbu_
00:00 Introduction
00:18 What is a Panel Chart or Shape Grid?
00:45 The Shape Grid Macro
01:07 Select Multiple Shapes
01:30 Specify the Number of Rows or Columns
01:48 Specify Space Between Shapes
05:12 The Macro Code