Aligning charts, objects on spreadsheet [excel layout tip]
Often when you are adding several charts to your report or project plan, it may be important to have them all aligned to a proper baseline – a fundamental design principle. Take a look at this:
But if you try to select each chart individually and adjust the alignment, it may not provide correct results as charts / other drawing objects can be moved by pixels instead of cells. Here is a simple trick to ensure proper alignment.
1. Select all the charts, objects you want to align to same baseline (top aligned, left aligned etc.)
2. Click on draw menu on the bottom right corner, select “Align or distribute” option, and specify your alignment choice like “align left” or “align bottom”
3. You can also distribute charts evenly across the available space on the sheet using this menu.
Btw, if you do not see “draw” menu, probably the drawing tool bar is not yet turned on.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« What they dont teach you in any school – Appreciation||Cool Visualizations of the Week [Aug 29] »|