In case you haven’t noticed, I’m a huge fan of Microsoft Excel (click here if you don’t believe me). I love Excel because it’s nearly free and can accomplish 99% of my data analysis tasks.
Sometimes evaluators are hesitant to use Excel. One misconception is that Excel is only good for 3-D exploding pie charts, boring bar charts, and random radar charts. But Excel can do more than you think!
Innovation Network recently published State of Evaluation 2012: Evaluation Practice and Capacity in the Nonprofit Sector. Click here to download the report. I loved the visualizations in the report and wondered if I could re-create them in Excel.
Here’s a screenshot from page 7 of State of Evaluation 2012. The visualization shows the percentage of small, medium, and large nonprofit organizations that used quantitative and qualitative evaluation practices. Quantitative practices were more common than qualitative practices, and medium and large organizations were more likely to use these practices than smaller organizations.
And here’s what I made with a little Excel elbow grease:
The formatting’s not identical, but that’s not the point. Did you realize that you can manipulate Excel to produce almost anything you want?
I challenge you to re-create this State of Evaluation chart in Excel or R — no expensive software allowed. Email me your submission or tweet an image to @annkemery. I’ll post the solution on March 12, 2013.
What do you get for playing? A coffee or beer together, my treat, the next time you’re in DC; a workout for your brain; and bragging rights. Game on!
Sheila B Robinson, Ed. D
Feb 26, 2013 -
I think the challenge is beyond my skill set, but what a great, innovative post! Are you able to say what program was used to create the original charts? I would love to see more of what Excel can do that most of us might not be aware of.
Ann K. Emery
Feb 27, 2013 -
Sheila, Your skillset might be closer than you think… I’m confident that you’ll be able to create these charts in the near future!
To create the original chart, our team sketched out what we wanted the chart to look like on paper first. Then we sent our designs to the graphic designer, and I believe she used an Adobe program (?) to turn our sketches into an electronic report. However, now that we’ve figured out how to create a variety of charts in Excel, it’s likely that we’d send her the sketches in Excel the next time around. Stay tuned!
Elena H
Feb 26, 2013 -
That is very cool, but how did you do it?? I am so often told that you “can” do these things in Excel, but I certainly don’t know how. Can you post a key at the end of this challenge? I would love to learn.
Ann K. Emery
Feb 27, 2013 -
Elena, Thanks for your interest! I’m glad that you’re excited to learn. I’ll post the solution in two weeks, on March 12, 2013. I plan to share the actual Excel file so you can see how I arranged the data and how I fooled Excel into creating this chart.
If you’d like to try it yourself, here’s a hint: I made a bubble chart in Excel. Try googling “how to make a bubble chart in Excel” to learn the basic structure of what I made.
Anna Mehrotra
Feb 27, 2013 -
What a fun idea! Just to clarify: you are asking us to re-create the same visualization that you re-created? Or another one from the report? Thanks!
Ann K. Emery
Feb 28, 2013 -
Anna, Good question. Yep, I’m challenging you to re-create the same visualization from page 7 of the State of Evaluation report. I’m not super picky about the formatting. You’ll notice the colors I used didn’t match the report exactly. The goal is simply to challenge your brain to use Excel is new ways (and, hopefully, have some fun in the meantime!)
Karen
Mar 1, 2013 -
I’m going to give it a shot Ann! Thanks for giving us a push to try it on our own 🙂
-Karen Anderson
Dataviz Copycat Challenge: The Answers | Emery Evaluation
Mar 12, 2013 -
[…] Two weeks ago, I challenged readers to reproduce a bubble chart from Innovation Network’s State of Evaluation 2012 report — using only Microsoft Excel or R. You can read the full blog post here. […]
Blog-o-versary! | Emery Evaluation
Mar 25, 2013 -
[…] More data visualization challenges […]
Dataviz Challenge #2: The Basic Bar Chart | Emery Evaluation
Apr 10, 2013 -
[…] first dataviz challenge was a hit! A few of you wanted to participate but weren’t ready to jump into a challenge that […]
Dataviz Challenge #3: The Side by Side Bar Chart | Emery Evaluation
May 24, 2013 -
[…] to everyone who participated in the first and second dataviz challenges! I hope these challenges give you a chance to practice and build upon […]
Ann's Blog | Dataviz Challenge #1: How to Make a Circle Chart in Excel
Jan 29, 2014 -
[…] Two weeks ago, I challenged readers to reproduce a circle chart from Innovation Network’s State of Evaluation 2012 report — using only Microsoft Excel or R. You can read the full blog post here. […]
Ann's Blog | Dataviz Challenge #2: Can You Make a Basic Bar Chart?
May 13, 2014 -
[…] first dataviz challenge was a hit! A few of you wanted to participate but weren’t ready to jump into a challenge that […]