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.














7 Responses to “Build models & dashboards faster with Watch Window”
yes, I use watches in excel vb
Dear Chandoo,
This is a quite useful for myself. I highly appreciate your efforts for acquainting us with this value adding and time saving tip.
I'll admit it, I never saw this feature before. I was familiar with using Watch Window in VB, but not in workbook. I'll definitely use this in future when building dashboards!
it was always great reading your blog, one thing that i want to know, which tool you are using to create such gif image?
it was also a nice post,,,,,, sir
Hello Sir,
Really very nice post. I didn't use this features in past. But now going to use it..
Thanks a lot for every time come up with something new..
Thanks
Very Nice post sir.
Every Time posting something new.. Thanks a lot