Beyond Excel: VBA and Database Manipulation

Oct 20 2014   12:45PM GMT

Executive Dashboard Must Have Add-in

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Tags:
excel
If you have dreams of developing executive dashboards in Excel, you need this add-in.
Drilldown
Drilldown PivotCharts Add double click drilldown to PivotCharts
Drilldown Results Management Use just one worksheet for all drilldown requests to end drilldown clutter
Embedded Chart Expand/Restore Expand small embedded PivotCharts to fullscreen and restore them to their original position by double clicking

Executive Dashboards
Executive Dashboards typically have several small graphs on a single page. These graphs are intended to provide a quick overview of a company’s key performance indicators (KPIs). Of course, when executives see something that doesn’t look right, they immediately want a closer look to confirm the graph is really displaying something odd.

The Big Picture
With this add-in, double click a chart to display it fullscreen and get a closer look. Once the odd condition is verified, executives want to know why their KPI is off. To answer that question we need a dive deeper into supporting data.

Diving Deep
With this add-in, double click a graph’s element/series to display supporting data. Oddly enough, XL’s pivottables support drilldown but XL’s charts don’t. They should. This add-in adds in what Microsoft left out.

Keep it Clean
While XL’s PivotTables support drilldown each drilldown request creates a new results worksheet. The more drilldown requests we make, the more clutter we create. With this add-in, results are directed to a single drilldown worksheet. Make as many requests as you like. This add-in keeps things tidy.

Summary
Like all BXL add-ins, Drilldown is free and the code unprotected. My purpose is to raise awareness within the developer community as to the power of Excel and VBA, and to help raise VBA developer skills. So use this to up your skills, or just use it. Get it here (see link below).

https://dl.dropboxusercontent.com/u/13737137/Projects/Input/Cursor.pdf Download the PDF at: https://dl.dropboxusercontent.com/u/13737137/Projects/Drilldown/Drilldown.pdf
Discuss this post or other BXL topics at: facebook.com/BeyondExcel

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: