Call Us! +44 7973 631102

Tip for Excel – How to make aligning and sizing chart objects a snap!

30 second tip icon

Here’s a handy Excel tip that took me years to discover. Making chart objects the same dimensions and getting them to line up precisely can be a real pain in Excel. If you a creating a dashboard with lots of chart objects this can become really time-consuming. The solution is to use the cell grid as an impromptu “snap” grid. Hold down the “alt” key before you resize a chart object and it should snap to the intersections on the cell grid. You can quickly snap all your objects to the grid, and even resize them by adjusting your column widths and row heights!

1 Comment

  1. Andrew on October 2, 2013 at 10:13

    Thank you Sir! Likewise a problem that has irritated me for so long (not too sure why it took me so long to google it..!).

    Kind regards

    Andrew

Leave a Comment