Four Fun Chart Hacks

Have you played around with Canva? It’s a great, free online design tool. It includes lots of images and gifs and is easy to learn. Canva has a number of simple chart designs that you can adapt to your needs. After starting a design in Canva, click on “Elements” and then type in “chart” in the search window to see the chart options shown in the image below. Each allows you to customize the chart by entering in a few data points.

But I wondered how I could use other options in Canva to hack out some fun charts. Scroll down to see what I came up with.

 

Chart Hacks

Start a design in Canva by clicking on the “Create A Design” button (upper right corner of screen), selecting a size (such as presentation), and then try one of my hacks.

HACK 1: Use images to build bars: For this bar chart hack, I selected “Elements” and then searched for images of backpacks and then stacked them (by dragging and dropping) to create a bar chart about homework completion. You can use the “Show Rulers and Guides” option on the File menu to make the bars the right length.

HACK 2: Use icons to make a pictogram chart. Pictogram charts use icons to represent small sets of data. Each icon can represent one unit or any number of units (e.g. each icon represents 10). For this chart, I found a human graphic by selecting “Elements” and then searching for “human.” Then I colored the icons to show the number of students with failing grades and added labels using the text option on the left.

HACK 3: Use grids and photos to create a timeline of programs and events. Select “Elements” and type in “grid” in the search window. Canva will give you a bunch of frame options. Choose one and then select “uploads” to import photos of your organization’s events and programs. Then simply drag and drop photos into the grid and label bars using the text option on the left as in this example. Drag in a photo of something white for the empty cells.

HACK 4: Use frames and videos to create moving charts. For a bar chart like the one shown below, select “Elements” and type in “frame” in the search window. Canva will give you a bunch of frame options. Choose a rectangle shaped frame and place in the design, using the “Show Rulers and Guides” option on the File menu to make your bars the right length. Then select “Elements” and type in a key word for the type of image you want. I typed in “water.” Under the search window, click on “Videos” to show only video elements. Then drag and drop videos into the frames and label using the text option on the left.

For something like the line chart shown below, select “Elements” and type in “chart.” Select a line chart option and fill in data as needed. Then type in “frame” in the Elements search window. Choose a circle shaped frame and place in design over a data point, adjusting size as desired. Then select “Elements” and type in a key word for the type of image you want. I typed in “glow.” Under the search window, click on “Videos” to show only video elements. Then drag and drop a video into the frame. Use the “Position” button in the upper right corner to place the video “backward” (i.e. behind the chart). Label using the text option on the left.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Connected Dot Plots

This week, I give you the connected dot plot. The name might not ring a bell, but I think you’ll recognize the face. It’s a pretty intuitive and useful chart for nonprofits. This is a continuation of a series of tips which introduce you to different chart types which are good for making sense of the type of data nonprofits collect.

Active Ingredients (What is a connected dot plot?)

A connected dot plot, aka “dumbbell plot,” shows the differences between two categories or two points in time. Usually circles indicate the values of each category or time period. For example, this segment of a larger chart from Pew Research Center gives us an intuitive way of comparing two age groups on their social media use. We can easily see where the gap is larger (Germany) and smaller (India). The stats to the right help to distinguish lines that are close in length such as the ones for Germany and France. Here are instructions for creating a connected dot plot with Tableau and Excel.

Uses

Connected dot plots can be much more effective in showing differences or changes over time than their more popular cousin: the grouped bar chart. Check out the two examples below which show the average score (on a five point scale) among respondents to a survey in 2018 and 2019. See which gives you a better sense of the change over time.

Grouped Bar Chart

Screen Shot 2021-08-16 at 11.35.55 AM.png

Connected Dot Plot

Warnings

In the examples above, the relative positions of the two categories or time points are the same in all cases: social media use was always greater in the younger group of users than in the older group, and the average score was always higher in 2019 than in 2018. What should you do when the positions flip flop? A good strategy is to call out these direction changes using arrows, colors, and/or legends as in this chart:


Fun Facts

Connected dot plots are sometimes called “Cleveland dot plots,” named for William Cleveland who, along with Robert McGill, studied different types of “encodings” in charts such as the length of a line, the area of a “slice” of a circle, and the position of a point along a common scale. They looked at what types of encodings humans decode most easily and, based on their findings, they designed a chart well-suited for human perception: the connected or “Cleveland” dot plot.

To see past data tips, including those about other chart types, click HERE.

Sources: Storytelling With Data and UC Business Analytics R Programming Guide


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


What You Should Know About Sunburst Charts

This is a new addition to a series of tips on different chart types. In each tip, l give you need-to-know information in a format akin to the “Drug Facts” on the back of medication boxes: active ingredients (what the chart is), uses (when to use it), and warnings (what to look out for when creating the chart). The idea is to fill up your toolbox with a variety of tools for making sense of data. This time I give you the sunburst chart.

Active Ingredients (What is a sunburst chart?)

A sunburst chart is a multi-level pie chart. Each ring corresponds to a level in a hierarchy, with the highest level as the inner circle or ring. Each ring slice is either divided equally under its parent slice or is proportional to a value. Color is often used to highlight hierarchal categories. Check out the example below. The inner ring segments show the number of participants in three program areas of a community center. The outer ring segments shows the number of participants in specific programs within the three areas. Scroll over segments to learn more.

Uses

Although the pie chart gets a bad rap in the data viz world, this pie chart cousin shines in certain circumstances. It works best (in my opinion) when you want to show not only a hierarchy but also how each component of the hierarchy differs according to some measure. For example, you want to show which components have the most participants or funding, or the highest survey ratings.

Here are instructions for creating a sunburst chart with Tableau and Excel.

Warnings

Sunburst charts with a large number of ring slices are difficult to read. A good rule of thumb is to abandon your dreams of a sunburst chart if any of the segment slices are too small to label. Once you need a color legend, as in the example below, use another type of chart such as a tree diagram or treemap. Also, I think a tree diagram works better when you are just showing a hierarchy and not how the components differ according to a measure.

Source: Oracle

Fun Fact

Here’s an early example of a sunburst chart, published in Mechanical Engineering in 1921 according to Think Design. It shows the average annual net expenditure of the US federal government from 1910 to 1919.

Source: Think Design


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Span Charts

Tired of bar and pie charts but not sure what your other options may be? Meet the simple and friendly span chart.

This is a new addition to a series of tips on different chart types. In each tip, l give you need-to-know information in a format akin to the “Drug Facts” on the back of medication boxes: active ingredients (what the chart is), uses (when to use it), and warnings (what to look out for when creating the chart). The idea is to fill up your toolbox with a variety of tools for making sense of data. And the span chart is a simple tool you can put to good use!

Active Ingredients (What is a span chart?)

A span chart shows the range between a minimum value and a maximum value. Check out the example below which displays the salaries of full-time employees of the City of Chicago in various departments. The chart on top shows the range between the lowest and highest salaries in each department, and when you click on a bar, the chart below shows the salaries of individual employees in that department (which you can see by scrolling over the circles). So we can see, for example, that although the public library department has a wide range of salaries, the large majority of employees earn less than $100K per year.

Uses

Span charts provide the extreme values. So if you want your viewer to appreciate the range of values and compare the range of different subgroups, as the example above does, it can be quite effective. In addition to salary ranges, a nonprofit organization might use a span chart to show the range between:

  1. The largest and smallest donation amounts per person by year or by subgroup.

  2. The highest and lowest grade point average of students in a tutoring program by semester or by subgroup.

  3. The most and least days of participation among adults in a job training program by month or by subgroup.

Here are instructions for creating a span chart with Tableau and Excel.

Warnings

Span charts do not show the values in between the minimum and maximum or the average value. So you have no sense of the distribution of data points. Are the values evenly distributed or are most at the high or low end? If understanding the distribution is important, you can pair a span chart with a chart that provides more information on the in-between values, as the example above does. Other chart types which show distribution include: histograms, scatter charts, and box plots.

Fun Fact

Span charts go by a variety of names including range bar/column graph, floating bar graph, difference graph, and high-low graph.

To see past data tips, including those about other chart types, scroll down or click HERE.

Sources: The Data Visualisation Catalogue


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Improve Your Organization’s Time Line

Here’s a simple data viz idea. Next time you make a time line showing your organization’s milestones, size those milestone markers (usually circles) according to some key measure. Voila! You are not only showing what happened but also your progress along the way.

The data for such a viz is super simple. Something like this:

Screen Shot 2021-08-24 at 9.01.48 AM.png

I connected the data shown above to Tableau Public (the free version of Tableau) to create the time line below. Vertical time lines not only suggest an upward progression but also work better on phone screens.

Dashboard 1 (3) (1).png

Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Showcase Your Sites With An Interactive Map

60-SECOND DATA TIP_3 (4).png

Here’s a viz you can use. It is interactive, can be built in Tableau Public for free, and can be embedded in your website. This example shows affordable housing sites. Give it a try below and check out these features:

  • The circles on the map show the location of the sites. The color of the circles show the type of site, and the size of the circles indicates number of units (but you can size your circles by any measure such as number of people served or programs offered.)

  • Click on a site on the map to see more information, to the right, about the site including a photo.

  • When you click on a site, it is also highlighted on the chart below so you can compare that site to the others.

To learn how to create an interactive map with similar features in Tableau Public, check out this tutorial. I’d also be happy to build one for you, customized to your needs. Just click “Schedule A Free Consultation” below.

Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Box Plots

60-SECOND DATA TIP_3.png

Here’s yet another in a series of tips on different chart types. The idea is to fill up your toolbox for making sense of data. This week, I give you the box plot.

Active Ingredients (What is a box plot?)

Like a histogram, a box plot shows how spread out your data points are. The box plot below shows the affordability of housing in neighborhoods in ten cities. Each red circle represents a zip code area. The gray boxes show where 50 percent of the zip code areas fall on the affordability scale (larger numbers mean more affordable, smaller ones mean less affordable). And the median (or middle number) is where the dark gray meets the light gray.

boxplot1.png

Box plots also show a lot of other information (see image below). Some call this type of chart “a box and whisker plot” because the lines extending from the boxes are known as the “whiskers.”

Source: Flowing Data

Source: Flowing Data

Uses

A box plot provides a detailed snapshot of your data. No data points are hidden or obscured by summarizing numbers such as averaging them. For example, Houston and Chicago have the same average affordability score (.13) but we can see at a glance that although they are similarly affordable cities, Houston has a wider range of affordability. And, we can see that although New York is, in general, more affordable than Los Angeles, New York has some zip code areas that are much less affordable than the median seems to suggest. There are also some extreme outliers including the circle at -1.0 affordability which is New York City's 10013 zip code area (Soho and Tribeca).

Warnings

Not everyone (or every application) draws a box plot the same. For example, sometimes the whiskers extend to the minimum and maximum values and others place outliers beyond the lines. However most box plots include the median, upper quartile and lower quartile.

Fun Fact

Mary Eleanor Spear invented what she called a “range bar” in the 1950s. It would later be known as the box plot.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Create A Map Dashboard To Show Your Organization's Reach

60-SECOND DATA TIP_3.gif

An interactive map is a great way to show donors, board members, prospective funders and other stakeholders whom you serve, including their age, location, income, and other characteristics. I’m doing a webinar on December 10, 2020 where I will teach you how to create an interactive map dashboard, like the one below, in less than an hour using Tableau Public, the free version of Tableau, a powerful data visualization tool. You can create a map dashboard with a simple Excel file, as long as it includes geographic data, such as zip codes. And you can embed the dashboard on your website, as I’ve done here. Play around with the dashboard below to explore the possibilities. And click HERE to register for the webinar.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


What You Should Know About Word Clouds

60-SECOND DATA TIP_3.png

This tip is a warning. In other tips, I have encouraged you to use a particular type of chart for specific purposes. But in this tip, I’ll suggest that you NEVER use this chart under ANY circumstance. I’m not alone is my aversion to word clouds. Plenty of others, including Jacob Harris, a senior software architect at The New York Times, have articulated their distaste. This tip is basically the 60-second version of Harris’ 2011 article on the topic.

Active Ingredients (What is a word cloud?)

A word cloud shows how many times various words in a document are used. More common words are larger. Less common ones are smaller. The varying sized words are arranged “into some vaguely artistic arrangement,” as Harris puts it.

Uses

There are no good uses of the word cloud. As its name suggests, it clouds meaning rather than clarifies it. I created the word cloud above using one of the many online word cloud generators. It shows the frequency of various words in “Goldilocks and the Three Bears.” Does it provide any insight into the story for you?

Sometimes organizations create word clouds not to convey insight but because they want a graphic on a topic and can’t think of what else to use. But photos or illustrations of almost anything are almost always going to be more engaging than a bunch of words floating around in a cloud.

Warnings

The number of times a word is used tells us nothing about the meaning of the text. Different words can have the same meaning and, conversely, the same word can have different meanings in different contexts. To get to meaning, you need to look at the frequency of concepts or themes, not words.

Word clouds aren’t the best tool even when the point is to analyze word usage. Check out the series of simple bar charts below. They provide more insight than any word cloud could because they allow us to easily discern the most/least popular words.

Source: NOW1051

Source: NOW1051

(Sort of) Fun Fact

The word cloud technique originated online in the 1990s when they were called “tag clouds” and were use to show the popularity of keywords in bookmarks.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Seeing Red, Blue, and Purple - What We Can Learn From Election Maps

60-SECOND DATA TIP_3.png

A wide range of election maps are in your immediate future. What you learn from those maps depends, in part, on how they are designed. Indeed, election maps and other types of maps can change our attitudes toward issues. In this 15-second tip, I recommend that you invest an additional couple of minutes watching The New York Times’ excellent slide show on how election maps can fool you. It will help you to be both a better consumer and designer of maps.

To see past data tips, including those about other chart types, click HERE.

Why You Should Know About Stacked Area Graphs

60-SECOND DATA TIP_3 (2).png

Another week, another useful chart to consider. This week, I give you the stacked area graph.

Active Ingredients (What is a stacked area graph?)

The stacked area graph is a variation of the area graph, which is simply a line graph with the area below the line filled in with color. In a stacked area chart, there’s more than one variable, so more than one line and shaded area. Additionally, these areas are stacked, one on top of the other.

Uses

Use this type of graph to compare the proportion of data units (people, groups, places, things, etc.) in different categories over time. This example from the Urban Institute does a great job of showing the relatively long sentences of those convicted of violent crime compared to the sentences of those convicted of other offenses. When this cohort of inmates entered prison in 2000, those convicted of violent crimes made up just 30 percent of the entire group. But 14 years later, they represented more than 80 percent of those still incarcerated.

2000 Entry Cohort by Offense Type

Warnings

It can be difficult to discern exactly how many (or what percent of) data units each band of color represents. The lowest band is clear. But you have to do some math to determine the other bands. For example, in the chart above, I have to subtract 30 percent from about 58 percent to determine the percent of inmates in 2000 convicted of property crimes (the yellow band). The line graph below does a better job of showing what percent of the overall cohort each offense group represented over time. So only use a stacked area graph when you want viewers to focus mainly on the proportion of data units in each group over time.

Dashboard 4.png

Fun Fact

A cool variant of the stacked area graph is the streamgraph in which the bands are placed around a central axis rather than stacked on top of an axis. The New York Times’s streamgraph on movie box office revenues helped to make streamgraphs popular.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Venn Diagrams

60-SECOND DATA TIP_3 8.47.59 PM.gif

This week, I give you yet another useful-if-done-right chart, the Venn diagram.

Active Ingredients (What is a Venn Diagram?)

ICYMI, a Venn diagram shows overlapping categories or sets usually represented by circles.

Uses

These diagrams are great for showing the degree to which categories or sets overlap and what elements fall inside/outside of each set and each overlapping portion. The take home message is usually the shaded area where all of the circles intersect. So make that area easy to locate using color and labels. This example shows how an organization bridges the gap among three different types of organizations working on foreign policy.

Source: Network 20/20

Warnings

For me, Venn-diagram-fatigue sets in early. I get tired of discerning the meaning of each overlapping area pretty quickly. So I’d suggest limiting the number of circles. And, more importantly, clearly labeling the sets.

Here’s one that I gave up on after about 15 seconds:

Source: @DanNeidle

Source: @DanNeidle

On the other hand, this Venn diagram works even with four sets because the sets (orphaned, wealthy, sidekick, and masked) are clearly marked and the intersection labels are simple.

Source: gliffy.com

Source: gliffy.com

Fun Fact

English mathematician John Venn is credited with inventing the Venn diagram in the 1860s, and, according to Phil Plait, there are two kinds of people in the world . . .

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Parallel Coordinates Plots

60-SECOND DATA TIP_3.png

Here is another tip in a series of tips on different chart types. The idea is to fill up your toolbox with an array of charts good for making sense of data. This week, I give you the parallel coordinates plot.

Active Ingredients (What is a parallel coordinates plot?)

Parallel coordinates plots look kind of like the electrical poles and wires along the highway. They are a series of axes (that’s the pole part) connected by various lines (that’s the wire part). Each axis represents a variable that you can measure numerically. Each line represents an individual unit, group, or category. For example, each line might be program that your organization offers. And one axis might be enrollment, another axis drop out rate, and another average rating on participant surveys. You can compare programs by seeing where each line hits each axis.

Uses

Parallel coordinate plots are great when you have a lot of measures and want to compare a bunch of individual units, groups, or categories on those measures. In the example below, each axis represents a different chronic illness and each line represents a state in the U.S. So we can see that the percent of adults with kidney disease is much lower than the percent of adults with arthritis across states. But we can also see where there is variation among states. For example, Oregon has a much larger percent of adults with depression than does Hawaii. The line for Hawaii is highlighted to allow the viewer to compare Hawaii to other states on various chronic illnesses. Note that in this example, each axis uses the same scale (percent of adults) but in some parallel coordinate plots, each axis has a different scale depending on the unit of measure appropriate for each variable.

plot.png

Warnings

The order of the axes will affect how the data is perceived. In the example, I ordered the axes from diseases with relatively low prevalence to those with relatively high prevalence to allow the viewer to easily distinguish diseases in this way.

Parallel coordinate plots can get cluttered fast. You can avoid this by limiting the number of lines or axes or by greying out most of them and highlighting just one or two as in the example above.

Fun Fact

Parallel coordinates plots go way back, to at least the 1880s when Henry Gannett and Fletcher Hewes published one in the Statistical Atlas of the United States. Check out their parallel coordinates plot which shows the ranks of states on a wide range of issues in 1880 including populations density (DC ranked number 1), per capita wealth (California ranked number 1), and literacy rate (Wyoming ranked number 1).

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Dot Matrix Charts

60-SECOND DATA TIP_3 (1).gif

I’d like to introduce you to yet another chart type. The idea is to fill up your toolbox for making sense of data. This week, I give you the dot matrix chart.

Active Ingredients (What is a dot matrix chart?)

Dot matrix charts show us data units as dots (or squares). A single data unit could be a person, a group of people, a building, a program, or any other thing that you are counting. Each dot is colored to show which category or group the data unit falls into.

Uses

Dot matrix charts are simple yet mighty. They give a quick overview of the relative size of different categories and how the parts relate to the whole. I was reminded of the power of dot matrices recently when reading about the COVID-19 School Response Dashboard in an article on the National Public Radio (NPR) website. The dashboard shows data drawn from reports from K-12 schools on their confirmed and suspected coronavirus cases, along with the safety strategies they're using.

If you check out the dashboard, you see these charts showing the percent of schools reporting cases among students and staff. Take a look at the Y-axis. It ranges from 0% to 1%. This allows you to see small differences between the charts on the left (confirmed and suspected cases) and the charts on the right (only confirmed cases). But it has a big disadvantage. It doesn’t give you a visual sense of just how few students and staff have, or may have, been infected based on data that schools have. (Note: A big unknown is the number of asymptomatic/untested students or staff. Rates might be higher if more students and staff were tested.)

student.png

NPR recast this same data in a dot matrix chart (below) with each square representing 50 people.* And the first thing you comprehend is that the vast majority of staff and students at the reporting schools have not been infected (again according to information that schools have). Without much more effort, you see that there are more suspected than confirmed cases. No need to inspect the Y-axis or subtract percent of confirmed cases from the percent of confirmed and suspected cases.

title.png
studentdots.png

Warnings

All those dots or squares require a good bit of page or screen real estate. Sure, one circle or square can represent more than one person or other data unit. But at some point, a bar chart might make more sense. Dot matrix charts work best when there are just a few categories and the aim is to communicate one or two simple messages.

Fun Fact

Dots or squares need not be displayed in rectangular form. This Policy Viz chart arrays the dots in a semi-circle to show the distribution of U.S. House members in different political parties. Gray dots represent empty seats. You can learn how to create a chart like this one using Excel HERE.

Source: PolicyViz

Source: PolicyViz

To see past data tips, including those about other chart types, click HERE.

*Note that the percentages displayed on the dashboard do not exactly match the numbers in the NPR dot matrix chart because the dashboard shows real-time data, and NPR used data from the dashboard on an earlier date than 9/24/20, the date when I took the image of the dashboard.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Sankey Diagrams

60-SECOND DATA TIP_3 (1).png

Here’s one more in a series of tips on different chart types. The idea is to fill up your toolbox for making sense of data. This week, I give you the Sankey diagram.

Active Ingredients (What is a Sankey diagram?)

Sankey diagrams use arrows or lines to show flow to and from stages in a process. The wider the arrow or line, the larger the quantity of flow. The arrows or lines may be colored to represent different categories or to show the transition from one stage to another.

Uses

Organizations are full of processes. Sankey diagrams help you to understand the flow of people, money, energy, or other things through a process. The example below shows the flow of undergraduate engineering students at the University of Pennsylvania from their summer internships and jobs to their employment and other experiences post graduation. We can see, for example, that most students who were in technology and financial services post graduation also were in those areas during their junior summer. However, students who started graduate school after graduation from college had a wider variety of experiences during the prior summer.

Source: The Signal

Source: The Signal

Warnings

Creating a Sankey diagram can be a challenge. You can’t highlight a data table and click “Sankey Diagram” in Excel. There are some programs designed specifically to create Sankey diagrams and others that will create a Sankey diagram with some hacking. Here is a great summary of software options.

Fun Facts

You may have seen Charles Minard's map of Napoleon's Russian Campaign of 1812 which shows dwindling troops across time and space (see image below). It’s a sort of Sankey diagram on top of a map and was created in 1869. However, the chart was named for Matthew Henry Phineas Riall Sankey, an Irish captain who created a chart in 1898 to show the energy efficiency of a steam engine.

Source: Wikimedia

Source: Wikimedia

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Use Big A** Numbers

60-SECOND DATA TIP_3 (1).png

You already know about BANs even if you don’t think you do. They are Big Ass Numbers meant to catch your attention. You see them everywhere these days, featured in bold fonts on websites, brochures, and reports; sprinkled throughout PowerPoint presentations; and arrayed as KPIs* in data dashboards.

BANs are having a moment. And they can be powerful. But watch out for overdoing it. When lots of BANs crowd a single display, they steal each other’s limelight and bewilder the audience. Anyone who gives a BAN a moment’s thought might wonder: “Wow, 5,000 meals sounds like a lot, but what is the need? What do similar organizations provide?”

So use BANs sparingly and give them space so they can shine. Also, provide context when possible: “5,000 meals served and no one turned away.”

Steve Wexler also advises using one or two BANs when they provide a good overall summary of a lot of data and when they clarify and provide context for subsequent charts, maps, and graphs.

And for some great ways to design BANs, check out Adam McCann’s 20 Ways to Visualize KPIs.

See other data tips in this series for more information on how to effectively visualize and make good use of your organization's data. 

*key performance indicators

Why You Should Know About Pictogram Charts

60-SECOND DATA TIP_3 (2).png

This is the seventh in a series of tips on different chart types. The idea is to fill up your toolbox with various types of charts for making sense of data. This week, I give you the pictogram chart.

Active Ingredients (What is a pictogram chart?)

Pictogram charts use icons instead of bars or circles, usually to show how many units are in a group. Probably the most common icon is the stick figure used to represent a person or a group of people (e.g. each stick figure represents 100 people.)

Uses

out+of+10+students+who+got+Little+Bit+support,+improved+their+attendance.+(3).png

Pictogram charts can be useful when bars or circles just seem too abstract, and you want to emphasize that you are talking about people, animals, apartment buildings, or whatever it is that you are measuring. Pictogram charts also come in handy when you want to clarify confusing statistics. Back in data tip #77, I used the pictogram chart below to compare the attendance of students in classrooms with attendance monitors to the attendance of students in classrooms without monitors, assuming 10 students per class. The chart was designed to clarify this statement: “54% more students with monitors improved attendance than students without monitors.” That sounds like a lot until you look at the chart below. The 54% stat is a “relative difference,” which is calculated as the absolute difference divided by the “standard” which, in this case, is the class without monitors. So 4.0 minus 2.6 divided by 2.6 or .54, which when expressed as a percentage is 54%. But the chart makes it clear that we are talking about 4 students vs. 2.6 students, which sounds much less impressive than 54%.

Warnings

Avoid showing too many icons. They are hard to count. Remember that one icon can represent a larger number. Also, don’t display partial icons. If you need to show a number with a decimal, consider showing the whole icon and coloring in just part of it, as in the example above.

Fun Fact

You can find free icons to use in pictogram charts at The Noun Project or at Flaticon.

To see past data tips, including those about other chart types, click HERE.

Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Gantt Charts

60-SECOND DATA TIP_3.png

This is the sixth in a series of tips on different chart types. The idea is to fill up your toolbox with different charts to make better sense of data. This week, I give you the gantt chart.

Active Ingredients (What is a gantt chart?)

A gantt chart shows the start and end date of a list of activities or tasks. Each row represents a task and each column represents a time period. Here is a gantt chart I made for Thanksgiving. In this case, the tasks are dishes. I used color to show different stages (preparation, cooking, refrigeration, and reheating) for each dish.

Thanksgiving+Game+Plan+2018-1.jpg

Here’s a gantt chart that may be closer to something you’d want to create for your organization:

Sample TIMELINE.jpg

Uses

Gantt charts provide a great way to show the different components or tasks in a project or program, how long each task is going to take, which tasks precede or follow others, and which tasks occur simultaneously. In the Thanksgiving chart, I was particularly interested in which dishes would be cooking at the same time since I have limited space in my oven. Similarly, a gantt chart can clarify if you have enough staff and other resources to conduct simultaneous tasks. You might consider adding a reference line to show the current date, shading portions of the bars to show what is completed and what is left to do, or adding arrows to show which tasks are dependent on each other.

Warnings

As with so many chart types, they can get overly complex and difficult to read. So keep the overall gantt chart simple to give a view of the entire project. If you need to show more detail, you can make related charts that zoom in on subtasks for each of the major tasks on the overall chart. Also, remember to update your gantt chart as timelines and tasks change.

Fun Fact

The gantt chart is named for its inventor, Henry Laurence Gantt, a disciple of Frederick Taylor, the great promoter of scientific management in the early 20th century.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Bullet Graphs

60-SECOND DATA TIP_3.png

This is the fifth in a series of tips on different chart types. The idea is to fill up your toolbox with various charts to make better sense of your data. This week, I give you the bullet graph.

Active Ingredients (What is a bullet graph?)

A bullet graph is a bar chart with context. In the example below, the orange bars show the number of enrollees in the Child Health Plus Program in five New York counties. The black vertical lines and the gray bars provide context. Each black vertical line shows the (fictional) goal for each county. The dark gray shaded bars show 60 percent of the goal, and the light gray bars show 80 percent of the goal. So we can see that Queens has surpassed its goal whereas Kings hasn’t reached its goal but has surpassed the 80 percent mark. These gray bars are called “performance ranges” and can be any amount that makes sense for the data and organization. Sometimes these ranges are labeled poor, average, and great.

Data source: https://healthdata.gov/dataset/child-health-plus-program-enrollment-county-and-insurer-beginning-2009

Data source: https://healthdata.gov/dataset/child-health-plus-program-enrollment-county-and-insurer-beginning-2009

Uses

Charting your data allows you to see the overall picture, patterns, and trends in your data. But without context, it’s difficult to really understand the implications of your data: where do you need to invest more time and resources, which groups might serve as models for others, etc. Bullet charts provide that context. You can quickly see which groups are meeting, exceeding, or falling below goals and by how much.

Warnings

As with bar charts, it’s usually best to display your bars in descending or ascending order. And use a limited number of performance ranges, usually no more than three.

Fun Fact

Data viz guru, Stephen Few, invented the bullet graph as an alternative to dashboard gauges and meters.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Why You Should Know About Histograms

60-SECOND DATA TIP_3.png

This is the fourth in a series of tips on different chart types. The idea is to fill up your toolbox with a variety of charts for making sense of data. This week, I give you the histogram.

Active Ingredients (What is a histogram?)

Histograms look like bar charts. Along the X-axis are “bins,” which each represent a range of values. The Y-axis shows how many units fall into each bin (as long as bins are equally spaced. See warning below.)

Uses

A quick look at a histogram shows you where values are concentrated, what the highest and lowest values are, and whether there are any gaps or unusual values. As such, histograms provide a snapshot of the shape and distribution of the data. Histograms are a great way to get to know your data and give you a much clearer picture than a simple average of your values would.

The series of histograms below provides a snapshot of how 87 students are doing in school. We can see that:

  • Absences, referrals*, and F grades are all relatively rare. A lot of kids fall into the zero bin.

  • Although missing assignments were also less common, most kids had some.

  • Reading and math test scores (MAP) were more “normally distributed” meaning lots of scores concentrated in the middle of the range, with the remaining scores trailing off symmetrically on both sides.

Source: http://www.storytellingwithdata.com/blog/2019/2/21/various-views-of-variability

Source: http://www.storytellingwithdata.com/blog/2019/2/21/various-views-of-variability

Warnings

If you make your bins too big or too small, it will be difficult to see the underlying pattern of the data. There’s no rule of thumb about how to size your bins. Play around with it to see what makes the overall pattern clear.

Technically, histograms are based on the area, not the height, of bars. The height of the bar does not necessarily show how many units there are within each bin. Instead, the height times the width of the bin gives you the number of units in the bin. However, most histograms that I run across have a standard sized bin, and under these circumstances, the height of the bin does reflect the number of units.

Fun Fact

Histogram = histos (Greek for mast) + gram (Greek for something written or recorded). So maybe the term was applied because the chart looks like a row of masts.

*I assume this means discipline referrals.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.