Lightbox Images on Excel Dashboards

Today’s Dashboard Design Tip from the Dashboard Spy: Showing Images in Excel with a Web 2.0 Flair!

Excel dashboards can use the Lightbox image technique so popular with blogs and websites these days. Have you seen the effect where you click on an image or a link to a form and the new content pops up in front and the underlying page dims to a dark gray or black? That’s called lightboxing.

Thanks to the always innovative dashboard experts at Juice Analytics who wrote the post, Lightboxing Images in Excel, we get this Excel Dashboard xls file (right click and save xls file) and accompanying image media.jpg (right click and save to root of C drive). Download those files to see the following effect:

Here is the Excel dashboard:

Excel Dashboard with Lightbox Image

When you click on the “Show” button, the speadsheet dims and the following image appears on top of the excel dashboard. To dismiss the image, you would click on it.

Excel Lightbox

The lightbox javascript is called Lightbox2 and is maintained by Lokesh Dhakar.

Be sure to visit the Juice Analytics post to read more about this lightboxing technique in Excel.

PS. Have you seen the latest Dashboard Videos on dashboards.tv?

Tags: Excel Dashboard, Images in Dashboards, Business intelligence dashboard design

2 thoughts on “Lightbox Images on Excel Dashboards

  1. Hi,

    Please help.

    The sample files work perfectly, but as soon as I try to replicate it in Excel 2007 it doesnt work all that well.

    The background shading does not appear and the buttons do not hide themselves when displaying the lightbox images.

    Your comments or suggestions would be higly appreciated.

    Thank you,

    Ruoall Chapman

Leave a Reply