Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail and chart yourself.
To make it more industrial-like, I’ve added:
1. Brushed metal background picture
2. Gradient fill format to the pie shares
3. A gradient fill. semi-transparent square (to make glass effect)
4. Sqrew-head pics
The original gauge chart template behind Egil’s industrious effort caused enough debate among our community.
I think gauges are a poor way to visualize data, but I don’t completely shoot them down either. Gauges connect well with certain type of audience / situations – like kids, informal communications, conveying just one point etc. But it would be disastrous to have a gauge chart on your weekly dashboard to the CFO, no matter how industrial-like it is.
Download Egil’s version of the Gauge
Click here to download the fancy gauge chart template. Thanks Egil for your idea. I think it is pimptastic.
Anyways, here is a fun challenge:
Download the gauge, and pimp it in your style. Take a screenshot, upload it somewhere and link it here. I want to see how you would pimp it.
And if you are furious to see a gauge chart on this blog, remember, and I am not making this up either, today is Friday. Have fun folks.
PS: yes, I am HUGE fan of Dave Barry, and no, I am not making this up.
Added later: Just to be clear, I think Egil‘s implementation is pretty cool and shows what is possible with excel.
5 Responses to “Number to Words – Excel Formula”
As well as the Indian version, perhaps you could look into an English version as against the American version.
Things diverge after one hundred with one hundred one OR one hundred AND one.
I'm sure that it is always AND after n00 or n00,000 where there any of those zeros have a value. So five hundred thousand and sixteen. There could be two and's seven hundred and eighty-six thousand four hundred and twenty-six.
Chandoo, you are a genius.
Hi Chandoo,
Please take a look at my NumToWords and NumToDollars formulas that I shared here:
https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433
That is a genius technique Robert. Thanks for posting it here.
100000000 One Hundred FALSE Million
Is there any reason for this error?