On Saturday we went to Columbus zoo, apart from enjoying the lions, penguins, birds, I have also learned 5 simple yet effective lessons in visualization.
1. Design your charts for kids – assume your audience knew bare minimum and curious

Above shown is a typical Zoo-mate info dashboard that you can see next to any animal in the Zoo, All the information that a kid needs to know to enjoy the reptile is shown there, a photo, whether the snake is venomous, what it eats, how endangered it is on a gradient scale and where its found usually.
2. Highlight information that is crucial, leave the rest

This is “How to read a Chameleon” next to Chameleon cage, quickly tells how to understand what you are seeing. But if you need to know more about the colors, the research behind it, there is a bigger section beneath this.
3. Use images, examples that your audience can relate to

This is the “measure your ecological footprint” exhibit. They have actually shown various sizes of shoes to compare ecological footprint of various Nationals – India, China, World average, US (not shown) so that kids can easily understand the point.
4. Remember, your audience is there to look at you, listen to your story, the chart is just an enabler

This is outside the area where tigers are kept. Obviously very few people stopped at this infographic, people are all curious to see the tigers. But this chart does tell a very good point about declining tiger habitat across the world, they have used 2 colors per each tiger to convey the point. No gradients or anything… just 2 colors, one for where tigers thrived earlier, and one for where they are today, and the point is obvious for even a kid.
5. Finally, have fun

Outside the building where reptiles were kept, I found this. Having fun in what you do is as much important as telling your story, selling your ideas.
Happy charting 🙂
PS: excuse the poor quality of images, it was dark in most of the places.













11 Responses to “Who is the most consistent seller? [BYOD]”
The Date column in the sample file is Text not Dates
[…] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]
Great Chandoo. Keep it up, Looking forward more from BYOD..
Thanks
With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.
This will do for invoice count
=COUNTIF(F:F,H12)
Instead of
=COUNTIFS(sales[SELLER],$H12)
Excellent document. How did you make the last graphic? Witch app. Thanks for answer.
Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))
Hi Chris,
=countif(sales [date],sales[date]) function is counting the unique dates in the table.
Vândalo
Excellent document!
Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?
How come the number should be smaller if there is more sellers?
Hi,
Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}
Please explain.
Thanks.