I’ve completed updating my Dashboard Tools Add-in to add a few new useful tidbits.
With the new features, you can create nifty infographics like this one:
Here are a few highlights of the new Dashboard Tools Add-in:
New InfoGraphic Shapes
I added new infographic shapes that feel a bit more modern.
New Map Shapes
I added a bunch of new map shapes to the Infographics gallery.
These maps have been designed so that each State/Province can be formatted separately.
Simply click the State/Province you are interested in and then format as needed.
To format multiple shapes within the group, you can click on each individual shape while holding down the CTRL key.
For example, to recolor Texas, click on it and format as needed.
You also have the option of pulling a specific State/Province out of the map.
Click the State/Province, then press Ctrl+X on your keyboard.
Click your worksheet and press Ctrl+V to paste it separately.
New Vector Icons
I added a new group of shapes I call Vector Icons.
When you click the Vector Icons button, you will see a gallery of components that can be used as icons in your dashboards.
The neat thing is that these are formatted as drawing objects.
This means you can size, add shadows, add transparency, and generally use these icon components just as you would any other shapes you add to Excel.
In fact, you can think of these as another set of shapes you can use in Excel.
In celebration of me getting off my lazy ass and actually getting this add-in updated, I’m giving it away FREE until Saturday.
You have until midnight U.S. Central time on May 7th.
Petros at Spreadsheet1.com has offered up his VBA Toolkit Add-in free for you DataPig readers!
If you don’t know, Petros is the one who developed that really cool Excel 2048 game featured on the Office blog a few years ago.
His offer is for a limited time as well. You can get his Addin-in at this link.