+'&title='+encodeURIComponent(document.title)+'&overview='+encodeURIComponent(document.title)+'&urllanguage=en&urlaffiliate=32003&encoding=UTF-8&urlpicture=http://www.viadeo.com/v_img14/shareit/viadeoflower.gif')
The attached workbook showcases the results of the Eurovision 2009 Song Contest, using an XY (Scatter) chart and a VBA class to add events to that chart so the user just needs to move the mouse over a country's flag icon to see the votes they received.
The bezier curves showing which countries voted for the selected country are drawn from named formulas that update based on which country is selected. I think it's pretty cool.
So there were 42 participant countries and this workbook plots all 42 of those European flags in one chart just below the bezier chart. No VBA is used to plot these flags, just formulas. The VBA is used only for selecting countries, by hovering the mouse over their flag icon.
I like the minimal interface that the VBA makes possible, but you must make sure that the top chart is selected in order for it to work. The workbook open event does this for you, but if you select anything else you'll have to click back on the top chart to get it working again.
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=d85d1222-25de-4a91-917f-6d40f4e76e1c)
If you liked this article, please share it!
Wow dude, this is really helpful information, thankyou.
My mind just got blown! Amazing work!
Great post! I really love your nice blog! I also commented at your other post that I thought was awesome. OH by the way, feel free to submit your blog to my free web directory. It will boost your visitors and backlinks!