New Dashboard Tools Excel Add-in

Today, I’ve published a new Excel Add-in.


.

.

About the DataPig Dashboard Tools Add-in

The DataPig Dashboard Tools Add-in is a utility that helps you quickly and easily create stylized graphics for your dashboard, find viable color schemes, and create dashboard mock ups. With the components found in the DataPig Dashboard Tools Add-in, you can easily add highly stylized components to your dashboards and reports. And because the components in this Add-in use the native Shapes found in Excel, they are completely customizable.

.

.

When the Add-in has been successfully installed, a Group named DataPig Dashboard Tools will appear on the Insert tab of the Excel ribbon.

In this group, you will see four galleries: Info Graphics, Canvas Builder, Color Swatches and Mockup Tools.

.

.

Info Graphics Components

When you click the Info Graphics button, you will see a gallery of all the available info graphics.

Simply select the graphic you want and it will immediately show up on your spreadsheet.


.

.

The component that populates your form is simply a collection of shapes that are grouped.

This gives you the ability to fully customize and link your Info Graphic to your data.

Actions you can take:

  • Delete individual shapes
  • Change Fill color
  • Change font color and size
  • Change outline color and thickness
  • Apply Shadows
  • Apply Gradients
  • Send Shapes to Back/Front (Right-click and Bring to Front or Send to Back)
  • Link Shapes to Cells

.

.

Canvas Builder Components

When you click the Canvas Builder button, you will see a gallery of containers that can be used to hold other components. Simply select the graphic you want and it will immediately show up on your spreadsheet.


.

.

 

.

Color Swatch Components

When you click the Color Swatches button, you will see a gallery of mock dashboards that have different color schemes. Simply select the graphic you want and it will immediately show up on your spreadsheet.


.

The purpose of this component is simply to give you a sense of dashboard-friendly color schemes (sort of like a color guide post). Each of these color swatches use colors from the Standard Office theme, so you won’t have to go through fancy RGB manipulations. After you select a swatch, you can click on a component in the group, and then take note of which fill and font color it is using.

.

.

Dashboard Mockup Tools

When you click the Mockup Tools button, you will see a gallery of dashboard mockup components that can be used pull together quick and dirty mockups.

.

When you mock-up a dashboard, you essentially build a “practice” dashboard to get a feel of what the components and layout will look like. Mockups give you and your client something tangible to look at and agree upon before diving into serious development work. Simply select the mockup graphic you want and it will immediately show up on your spreadsheet. The idea is to insert various components from this section to build an electronic dashboard mockup you can use.

.

.

Like It? Get it Today!

Get the Add-in

10 thoughts on “New Dashboard Tools Excel Add-in

  1. Dave

    Great idea for an Add In. Did you include the mock ups from your “Silly Dashboard Idea” post as well? There was a lot of positive interest in those shapes and font too. Cheers!

  2. datapig

    Dave:
    I’ve included the background (in the Canvas Builder section of the Add-in).

    I dropped the idea of the stylized charts (it was too hard to get real charts to do look like that).

  3. Dave

    Thanks Mike. Shame about the stylised charts as they look really cool, although I’m not sure how well they’d go down in some business environments anyway but I reckon you’ve definitely hit on some very different creative tools here – awesome work!

  4. Azounet

    Hello DP,

    Great idea to share all these mockup tools as an add in.

    If it’s possible, can you explain us in a further article how you created the addin ? The issue, the solutions and so on ?

    Regards

  5. Andrea R

    I won a copy of your add-in from Debra at the Contextures website and I love it! It is great for breaking out of a rut and coming up with new ideas for data display or putting in a placeholder until I have time to build something. Additionally, I am color-dumb so it’s nice to have some palette help. My one comment there is that there is a lot of orange in your palette, and the big boss HATES orange 😉
    Great work though, and thanks.

  6. Jerom

    Could you please tell me how to install this add in and from where?
    I tried a lot but could not find the exact one.

Leave a Reply

Your email address will not be published. Required fields are marked *