Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...
How-to Easily Paste a Defined Name in Chart Dialog Box
As you are learning to use Excel to develop your Executive Dashboard Templates, you will quickly learn that Defining Names are your friend.
Defined names...
QUICKLY Change Microsoft Excel Dashboard Template Cell References
Learn Excel Quickly:
Okay, when you are making your Excel Dashboard Templates you will spend a lot of time settin up formulas and copying them...
How-to Copy Charts and Change References to New Worksheet
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data? Perhaps you...
How-to Add Custom Labels that Dynamically Change in Excel Charts
Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog...
