I’ve been pretty busy with client work, so no new blog post today. I did, however, want to share some updates I’ve made to my Dashboard Tools Add-In.
If you don’t know yet, the Dashboard Tools Add-in is a utility that helps you: enhance your dashboards with stylized graphics, find viable color schemes, and create dashboard mock ups.
For this update, I added two new tools: a Color Capture tool and a Customize Percentages tool.
The new Color Capture tool is based on the eye dropper tool developed by
Excel MVP Andy Pope a few years ago. Being the excellent cat he is, Andy was gracious enough to let me steal his code for this tool (Cheers Andy).
The purpose of this tool is to easily capture desirable color schemes from a screenshot, a photo, or from another dashboard. Simply click and hold the eye dropper icon; then while continuing to hold the left mouse button, drag across the screen to your desired color. Once you have your desired color, you can add that color to your Recent Colors panel for future use. Play the video below to see it in action.
The purpose of this tool is to provide you with an enhanced set of options for formatting the percentages in your dashboard. Excel gives you almost no built-in options for applying custom number formatting to percentages. In five easy steps, you can change that by leveraging some nifty custom number formatting tricks via a simple interface. By going through these steps, you can take bland percentages and transform them into mini visualizations.
- Choose the colors to use for both positive and negative percentage numbers.
- Choose the symbols to include in your percentage formatting.
- Select the number of decimal places to show.
- Select the range to apply the formatting.
- Click the Apply button.
Here are a few examples of some of the formatting combinations you can easily create with this tool.
If you’re interested in purchasing this Add-in, it’s only $14.95 at my website.
If you’ve already purchased the previous version of the Dashboard Tools Add-in, you can email me with the subject line “New Dashboard Tools Update”. I’ll check the PayPal logs for confirmation, and then I’ll send you the free update. You can save me a bit of time, by including the original email you received when you first purchased the Add-in.
I’ll be back next week with new content. Have a great weekend!