Dataviz Copycat Challenge!

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.

state_of_evaluation_actual

And here’s what I made with a little Excel elbow grease:

state_of_evaluation_excel

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!

11 thoughts on “Dataviz Copycat Challenge!

  1. Sheila B Robinson, Ed. D

    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.

    Reply
    1. Ann K. Emery Post author

      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!

  2. Elena H

    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.

    Reply
    1. Ann K. Emery Post author

      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.

    1. Ann K. Emery Post author

      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!)

  3. Pingback: Dataviz Copycat Challenge: The Answers | Emery Evaluation

  4. Pingback: Blog-o-versary! | Emery Evaluation

  5. Pingback: Dataviz Challenge #2: The Basic Bar Chart | Emery Evaluation

  6. Pingback: Dataviz Challenge #3: The Side by Side Bar Chart | Emery Evaluation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s