Dashboards by Example
    Dashboard: Examples & Best Practices.   From Excel Dashboards to Enterprise Business Intelligence, these dashboard implementations contain KPIs, metrics, charts, trends and more.

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers and I.T. trade magazines at no cost.

« First Spreadsheet Dashboard
So Where are the Excel 2007 Dashboards? »

Customizing Ribbon Buttons for Excel 2007 Dashboards

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:

Excel 2007 Ribbon Icons - Datapig utility

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:

Enter details of custom excel 2007 ribbon buttons

You can output either raw XML or a sample worksheet.

Output of Excel 2007 Custom Ribbon Button

Here is the result - a new tab and buttons for Excel 2007:

Excel 2007 Custom Buttons and Tabs

You would tie your button to a macro:

Custom Excel 2007 Button and 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

Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.  


What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

Leave a Reply




Last Modified: Sunday, July 27th, 2008 @ 21:09

This business intelligence dashboard blog entry was posted on Thursday, May 22nd, 2008 at 12:34 pm and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Learn how to create Excel dashboards.

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?