Alberto Cairo’s How Charts Lie: an Alt-Disappointed Book Review
The Excel Charts Data Visualization Blog
by Jorge Camoes
4y ago
To tell you the truth, I don’t like the word “lie”: it feels obvious and unsophisticated. I prefer something like “reframing truth”, “alternative facts” or an English world I recently discovered, “paltering” (lying with the truth). Wanting to improve my skills in that area, I had great expectations about Alberto Cairo’s most recent book, How Charts Lie: Getting Smarter about Visual Information where he discusses this topic at length. Well, after reading it, my dark side found the book incredibly boring. The intellectual satisfaction of learning new and mischievous ways of deceiving others is j ..read more
Visit website
Excel: sort + COUNTIF() = utter mess
The Excel Charts Data Visualization Blog
by Jorge Camoes
4y ago
I’m still in shock. Such a stupid Excel mistake. I should know better, but it was Monday, so… Let me tell you about it. It’s as mistake as old as the hills, but it never goes away, and you are not immune to it. I’ll exemplify with a simple data set. Here is a list of counties by state in the US (the data source), then the number of counties by state and finally the states sorted by number of counties: I couldn’t use a pivot table, so I had to count them with the COUNTIF() function. Then the states are sorted by the number of counties. Here is the formula I’m using, a typical COUNTIF() fu ..read more
Visit website
Announcing: Wisevis data visualization courses
The Excel Charts Data Visualization Blog
by Jorge Camoes
5y ago
I’ve been working on a series of short, focused and practical data visualization courses that will be published on wisevis.com, my consulting firm’s site. The plan is to add two new courses each month (minimum), update and move my current dashboard courses and convert my e-books to the online course format. There will be free and paid content. Course for fun: How to make a pie chart I couldn’t resist the temptation of creating a course on How to make a pie chart as a “Hello World!” message. It’s free, so you don’t even need to enroll. Although it is free and about pie charts, this ..read more
Visit website

Follow The Excel Charts Data Visualization Blog on FeedSpot

Continue with Google
Continue with Apple
OR