A couple of days ago I pointed Ruth from “My Paper Work” to Excel Web App, as a way to create an Excel calculator embedded in a blog post. She created a post, with an Embedded workbook that translates hourly and annual income to a per minute rate, and then gave a table of how much various jobs earn per hour (in the U.K.). Her post, “How much is your time worth?” is here. I think that the way Ruth used Excel Web App is a really great way to get started. Very cool! I love to see Excel in action.
While reading it, I thought of what other ways people can use Excel to create an interactive, live experience in their blogs, while using graphics to tell a story and keep their users engaged. I’ve tried the following version:
In this example, I’ve used color scale conditional formatting on cells to show the range of pays for different jobs, and also created a simple bar chart to visually compare ones hourly rate with that of other jobs. A picture is worth a thousand words…