Excel Dashboard Update:
Here are some recent pointers to resources that are very helpful to excel dashboard builders and users.
This is an excel sales dashboard template for you to download and reuse:
This is a video on excel reporting and how a dashboard view can enhance excel reports:
This is the link for future info on these excel management reports:
Building a dashboard with Excel 2007? Don’t forget to make use of the Excel 2007 ribbon. You can add your own custom tabs and buttons to the Excel ribbon using XML or RibbonX code. Thanks to Mike Alexander, author of Excel 2007 Dashboards & Reports For Dummies, there is a freeware Custom Button Builder for Excel 2007.
As this Excel 2007 Custom Ribbon Buttons video tutorial shows, the utility asks you to fill out a table of values and it provides a sample worksheet with your custom tabs/buttons (complete with icons and code that can call your macros).
Let’s have a look at some screenshots I captured from the video:
You can select from the billions of icons on your machine:
Click to see more of this Excel 2007 Ribbon Customization utility:
You fill out this table for each item that you wish to appear on the ribbon:
You can output either raw XML or a sample worksheet.
Here is the result – a new tab and buttons for Excel 2007:
You would tie your button to a macro:
Visit the datapig site for further details.
Tags: Excel 2007 Ribbon Customization, Excel 2007 Dashboards, DataPig Technologies Excel 2007 Utility, Michael Alexander, Microsoft Excel 2007 Ribbon Custom Buttons