Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion
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
Click here to download the MP3 file.
Links & Resources mentioned in this podcastRecommended 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 PodcastOther options to subscribe
The post CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.