2 Comments

  • Shelly says:

    Please reveal how to create this chart! I messed w/ scatterplot a bit; have an idea to mess more but am on a deadline and just want to do it! Thank you!

  • Shelly says:

    I figured it out! Using it to show ATOD use among high school students in the first quarter of this school year. Now I need to figure out how to use the drug symbol to represent the drug.
    Thanks for your examples!

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Dataviz Challenge #6: Can You Make a Unit Chart?

    Updated on: Oct 11th, 2013
    Data Visualization in Excel
    , ,
    Collage of clipboard, clock, people, calendar and calculator.

    Lately I’ve been feeling let down by summary statistics: the min and max, mean and median, quartiles and standard deviation… They do their job well enough. Summary statistics tell a summary. An aggregate story, bringing all the messy scores together into some sort of cohesion. We grab the averages and stick them in bar charts.

    But sometimes we don’t want to summarize, we want to highlight the variety in scores and remind readers that the chart is actually made up of individual people, not just the mean or median. Long live the messy data, the dispersion, the distribution, the spread!

    Example of a unit chart.
    I could tell you a few descriptive statistics: min = 26%, max = 100%, Q1 = 64%, Q3 = 83%, median = 74%, mean = 73%, standard deviation = 15%. Or, I could show you the spread in this unit-chart-turned-histogram.

    Unit charts are not your new go-to chart. They do not replace bar charts. They are not appropriate for all datasets. They’re best for those few moments when you choose to emphasize individual units of data. A unit could be 1 person, or 10 people, or 1 school, and so on. Units can be represented in circles or squares or triangles. Units can be stacked on top of each other to form a histogram, or they can be plotted along a line.

    The dataviz challenge: Re-create the chart in in Excel, R, or some other free software program. Then, tweet a screenshot to @annkemery.

    Bonus: Make a unit chart for your own data. Or, do you emphasize individual differences with other chart types? Share your ideas with the community!

    The prize for playing: A professional development opportunity and bragging rights. I’ll post the how-to guide in a couple weeks.

    Want to learn more? I’m presenting about charting techniques at the American Evaluation Association’s annual conference on Thursday, October 17, 2013 at 11am in Washington, DC. Hope to see you there!

    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

    2 Comments

  • Shelly says:

    Please reveal how to create this chart! I messed w/ scatterplot a bit; have an idea to mess more but am on a deadline and just want to do it! Thank you!

  • Shelly says:

    I figured it out! Using it to show ATOD use among high school students in the first quarter of this school year. Now I need to figure out how to use the drug symbol to represent the drug.
    Thanks for your examples!

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    You Might Like

    Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

    Enroll

    Adding Text Boxes to Charts in Excel: Slow vs. Fast

    Are your text boxes not copying/pasting correctly from Excel into Word or PowerPoint? You might need to “group” the text box and chart. Or, better yet, be proactive and trap the text box inside the chart from the beginning.

    More »

    Need practical how-to tips? In this course, you’ll learn how to make great graphs inside software you already have. Includes beginner, intermediate, and advanced tutorials for making charts from start to finish.

    Enroll

    Subscribe

    Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.