Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video I explain how to use the Snap to Shape feature in Excel to resize & align all the charts, slicers, images, and shapes on your dashboards.
This technique helps save time when aligning all the elements on your dashboard, and is a good alternative to the other Align buttons.
Snap to Shape is a mode we can toggle on/off in Excel. It's a pretty simple feature. When we move a shape by dragging it with the mouse, it will snap into alignment with other shapes on the worksheet.
This also works when we are resizing shapes with the mouse. It makes it quick and easy to align all the elements on a dashboard, flowchart, org chart, or any other project in Excel where you have a lot of shapes on the worksheet.
Here is a link to the article with step-by-step instructions: https://www.excelcampus.com/charts/dashboard-snap-to-shape-alignment/
Here are links to other videos mentioned in this video:
Intro to Pivot Tables & Dashboards part 1 (learn how to build the dashboard used in the video): https://youtu.be/9NUjHBNWe9M
Intro to Pivot Tables & Dashboards part 3 (learn how to align shapes with the Align buttons): https://youtu.be/FyggutiBKvU