is a fantastic online invoicing and time tracking service. I use it and love it. In just over the first four months of this year they reached $1 billion US in invoices run through their system, and to celebrate they published a very interesting chart
. The chart was originally designed by interactivethings.com
. I thought I would recreate it in Excel with a twist - animation.
It's pretty faithful to the original, with the added ability to sort the chart by countries with the most or least average invoice amounts; or with the most or least average time-to-pay on the invoices; or simply alpha or reverse alpha. You do this by clicking the legend to the left of the chart, as demonstrated in the above animated GIF.
This is a very advanced Excel chart, sporting bezier curves, bubble chart overlay with VBA rendered proportional font sizing, combination stacked bar chart and XY scatter chart, all series fed by named formulas with the original data in a data sheet with no supporting (cluttering) columns, two-dimensional dynamic range as the foundation of virtually all formulas, essentially no use of the IF function, animation with easing, VBA rendered font color fading, data sorting via the Sort method of the Range object, and liberal use of shortcut range references
in the VBA. This is an instructional goldmine so please be sure to download the workbook.
I think it all came together quite nicely.
I placed the map behind the transparent charts in order to avoid the speed penalty of using a graphic as the back fill of a chart. I used this map
from wikimedia.com. I lightened it up in Adobe Illustrator and used a circle vector mask to blow-up Europe, as was done in the original. It's the only way to separate the bubbles of Europe enough so that their labels don't overlap.
So what are your thoughts on this bad boy?
Here's the chart.
And here's a list of other animated charts on Excel Hero:
If you liked this article, please share it!