Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]
In the recent How to visualize survey results using Incell Panel Charts I have presented an easy way to create panel (or trellis / small multiples ) chart using Excel’s Incell Charting capabilities. That post is inspired from beautiful work done by Jon on Stacked Bar Chart Alternatives. Naomi B Robbins, who is an author and writer (visit her site: NBR – Graphics) has written a follow up article on this in which she suggested a dot-plot like this:
Jeff, who is a sweet fella from down under pointed that Naomi’s dot plots too can be incellified easily with excel. He suggested that I do a follow up post and show how an incell dot plot can be created for same data. I always look for opportunities to make you awesome in excel and Jeff’s request sounded just the right thing to do. So here is the incell dot plot for the same survey data – without further ado…
Incell Dot Plots in a Panel
The chart works exactly same as earlier one. Instead of REPTing | symbols, we used – (hyphens) and then a big black dot in the end (char code x25CF). Since today is a Friday, I am refraining from a lengthy post explaining how this is done. Instead, download the source file and learn yourself. Here is a clue…
- Incell Dot Plots – Example
- Dot Plots in Excel – Recommended Add-in from Jon
- More articles and tutorials on Excel Incell Charting
- Recommended: Naomi’s Creating More Effective Graphs book
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Make your Chart Legends Legendary||Speaking at TechEd 2010 on “How to Select the Right Chart for your Data” »|