In the 38th session of Chandoo.org podcast, Let’s optimize data to ink ratio of your charts.
What is in this session?
In this podcast,
- Announcements
- What is Data to Ink Ratio?
- Obvious ways to optimize Data to Ink Ratio
- More ways to optimize Data to Ink ratio
- Highlighting what is important
- Conclusions
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Recommended Books for creating better charts:
- Information Dashboard Design by Stephen Few
- Visual Display of Quantitative Information by Edward Tufte
Optimizing data to ink ratio – Charting case studies
- Closing gaps in gender equality chart
- Why 3D pie charts are evil…
- Visualizing world education rankings
Techniques for highlighting what is important
- Display alerts in dashboards to grab user attention
- Adding meaning titles & legends to charts
- Never show simple numbers in your dashboards
Invitation to “Becoming a better analyst” Webinar
As mentioned in the podcast, I am running my first ever webinar on Wednesday, July 15th – 2015 (2PM EST). The topic is “How to become a BETTER analyst?”
Please click here to register for the webinar & become a better analyst.
Transcript of this session:
Download this podcast transcript [PDF]
How do you optimize Data to Ink Ratio?
What about you? Do you worry about data to ink ratio when making charts? How do you optimize it? Do you have a process for it? Please share your tips by posting a comment.
Subscribe to Chandoo.org Podcast
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?