Aligning objects in your Excel dashboard

Your dashboard will typically have a number of different objects, maybe some text boxes, shapes and charts, etc. As you’re building it up and making changes if you find it’s taking lots of manual time lining everything up, you may find this tip useful.

 

In this simple example, we just have two charts we want to align with each other.

 

 

AligningDashboardObjects1

 

1) Highlight all the objects you wish to align.
2) Go to Page Layout, and then Align from the Arrange section of the ribbon.
3) Choose from the drop-down menu whether you’re aligning to the left, right, top, bottom, etc.

 

AligningDashboardObjects2

 

In this case we’re aligning left. This means all selected objects will align to the leftmost of the selected objects.

 

AligningDashboardObjects3

Leave a Reply

Your email address will not be published. Required fields are marked *