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!
Tip for Excel – How to make aligning and sizing chart objects a snap!
June 18, 2012 By Leave a Comment