Hi,
We’ve been struggling with how to make this table reader friendly for the non-data literate. Please help! This table is included in a larger report that will be distributed to community agencies with varying levels of data literacy. Please provide help using Excel—we don’t have access to other software programs (unless they are free!).
Data are available here.
You have the same data counted in multiple locations in the table as it stands, which could confuse the audience if they are not too numerate. Also, you provide enough information in the table as it stands to fill in the blanks.
In reformatting the table I’ve preserved your font and colour choices, but removed much of the redundant information.
Unsure how to attach the reformatted data-set, so I’m including an image with my comment.
With correct picture…
I would turn your table into a chart. I think a diverging stacked bar chart makes the information easy to digest, but for something even simpler to create in excel a standard stacked bar works also. I have stripped even more of the data from the table out, focusing on the percentages and the total number of participants.
I think this is a great solution overall, and the color choices are much improved.
Whether or not it will suit the original poster’s needs is another matter, but it’s a nice clean presentation.
and the standard stacked bar
Ooops. Bars were incorrectly ordered/labelled in previous comment.
+1 Agreed. Stacked bar is an improvement.
I’m not easily imepsserd. . . but that’s impressing me! 🙂
I’ve been looking for a post like this for an age
Free knowledge like this doesn’t just help, it promote democracy. Thank you.
Keep these articles coming as they’ve opened many new doors for me.