4 Comments

    Leave a Reply

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

    Span Charts: When You've Only Got the Min and Max

    Oct 29th, 2014 / Data Visualization / , ,

    A few months ago I received a copy of the Chronicle of Philanthropy. An article about nonprofit CEO salaries caught my attention.
    1_dataset_10_charts_nonprofit_ceo_edition_1
    Let’s zoom in and check out that data table:
    1_dataset_10_charts_nonprofit_ceo_edition_2
    Nevermind that the data (salary ranges) has nothing to do with the article (turnover).
    Rather than displaying a mean or median, the article displayed a range. A range! What a challenge. I had to figure out how to best visualize that range.
    During all my workshops, I encourage attendees to sit down and sketch on blank paper before turning to their computer and getting frustrated by Excel’s limited menu of chart options. Sketch first and free your mind, figure out the software second.

    Draft #1

    First I drew an exact replica of the data table from the article – CEO salaries, CDO salaries, Washington, and New York.
    I actually hadn’t realized that Washington and New York salaries were nearly identical until I sat down to sketch.
    1_dataset_10_charts_nonprofit_ceo_edition_3

    Draft #2

    Since New York and DC salaries are nearly identical, why display them a few inches away from each other? This draft places New York and DC’s salaries directly beside each other.
    1_dataset_10_charts_nonprofit_ceo_edition_4

    Draft #3

    I decided that I wasn’t really interested in CDO salaries, only CEO salaries.
    1_dataset_10_charts_nonprofit_ceo_edition_5

    Draft #4

    The data table gives us aggregate/summarized numbers.
    If I had the raw data (I don’t), I could visualize each CEO’s unique salary in some sort of dot plot/pictograph/scatter plot-esque chart.
    1_dataset_10_charts_nonprofit_ceo_edition_6

    Draft #5

    If I had the raw data, I could create an actual scatter plot that mapped out the connection between nonprofit size and CEO salary, maybe annotating one cluster of salaries.
    1_dataset_10_charts_nonprofit_ceo_edition_7

    On the Computer

    There are probably a million more options, but I’d sketched a few ideas, and was ready to sit down at my computer and try to design the real thing.
    I decided to create a twist on Draft #2.
    Yes, this is good ol’ Excel.
    1_dataset_10_charts_nonprofit_ceo_edition_8

    Another Option: Displaying Ranges in Line Charts

    You’ve seen how I might visualize a minimum and maximum value in a bar chart.
    But what about line charts?
    Here’s a great example from the New York Times.
    Rather than displaying exact numbers, the New York Times displayed a range in this line chart. These are estimates, after all. Displaying an exact mean, median, or frequency count wouldn’t make sense.
    As usual, the screenshot doesn’t do it justice. Head over to http://www.nytimes.com/interactive/2014/07/31/world/africa/ebola-virus-outbreak-qa.html#model to explore the charts.
    nytimes_line_chart_range
    How have you graphed your data when you only have a min and max? Share your ideas below.

    4 Comments

      Leave a Reply

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

      Related Courses

      Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips. You’ll never look at reports the same way again.

      Learn More

      Data visualization best practices, practical how-tos, tutorials in multiple software platforms, and guest experts. Designed with busy number-crunchers in mind.

      Learn More

      SPONSORED

      #f-post-el-35{display:none !important}

      #f-post-el-35{display:none !important}

      Learn More