• Home
  • Contact
  • Service Offers
    • Advice
    • Training
    • Support
  • May 26, 2013

Made to Measure KPIs

Practical help with KPIs, measures and reporting

  • Tips
  • Tools
  • How To
  • Checklists
  • Design tips
  • Opinion
  • Reviews
  • Buy BlinkReporting
You are here: Home / Post / Tip / Tip for Excel – How to make aligning and sizing chart objects a snap!

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

June 18, 2012 By Bernie Leave a Comment

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!

Related Posts

  • BlinkCharts, what they are and why you need themBlinkCharts, what they are and why you need them
  • 9 Things you should never do in Excel9 Things you should never do in Excel
  • 30 Second Tip: Seek out pain30 Second Tip: Seek out pain
Zemanta

Bernie

Bernie has helped his clients deliver surprising levels of improvement across a wide range of industries over the past 15 years. His mission is to help clients with a repeatable, practical and jargon-free method for generating insightful and clear KPIs and management reports. He understands that most people don’t get excited by KPIs, but believes it’s a curable condition.

More Posts - Website - Twitter - LinkedIn

Share this:

  • Email
  • Print
Filed Under: Tip Tagged With: align, alt, excel, grid, resize, snap, tip

Speak Your Mind Cancel reply

*

*

Get new posts by email…

Return to top of page

Copyright © 2013 Made to Measure KPIs · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.