Here goes the screenshot, explanations will follow !
Works more or less like the Heatmap() UDF and has contextual tooltip when hovering on a sector.
Ok, not a Sparkline anymore, but a usefull feature for dashboards.
I will come back after some debugging.
5 comments:
Fabrice -
This is impressive. Your little hobby (SfE has become quite an obsession!
Thanks Jon, glad you like it ! ;-)
and Yes ! this damn thing is an obsession, and a pretty pointless one as there are plenty of professional tool out there... but it's fun !
I tried CO2 emission treemap in EXCEL 2010 and It gives errors for columns G36, G37, G38 and L43. It shows #NAME? in these cells. What am I doing wrong?
I downloaded file Sparklines.xlam and copied it to C:\Program Files\Microsoft Office\Office14\ADDINS
Before opening CO2 emission Treemap.xlsx file I opened Sparlines.xlam
Thank you,
Suhas.
Suhas,
you should follow the steps described here to install an add-in : http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/
Sir, I bow in respect. Years ago I tried the addon and after some experimentation I concluded it wouldn´t go very far, it was too amateurish. I was wrong! It grew immensely !
You have my admiration for the development and for keeping this project freely availabe.
Greetings from Portugal
Post a Comment