I have a project where we are sampling data. We have 1,000 toys. All 1,000 fall into 1 or more group or none of them:
Group 1 - Approriate for ages 5-7
Group 2 - Approriate for ages 8-10
Group 3 - Approriate for ages 11-12
Any toy may be part of 1 group, 2 or all 3.
I have gathered all this data into a spreadsheet for the different combinations:
Group 1
Group 2
Group 3
Group 1 Only
Group 2 Only
Group 3 Only
Group 1 AND 2 AND Not 3
Group 1 AND 3 AND Not 2
Group 2 AND 3 AND Not 1
Group 1 AND 2 AND 3
Not Group 1 AND Not 2 AND Not 3
Group 1 OR 2
Group 1 OR 3
Group 2 OR 3
Group (1 OR 2) AND Not 3
Group (1 OR 3) AND Not 2
Group (2 OR 3) AND Not 1
All Docs
Now I need to chart this. Yep. You heard me.
I have a Venn Diagram, which I manually created (overlapping circles)
One shows exclusive data for the 3 circles:
Group 1 Only
Group 2 Only
Group 3 Only
Group 1 AND 2 AND Not 3
Group 1 AND 3 AND Not 2
Group 2 AND 3 AND Not 1
Group 1 AND 2 AND 3
The other is inclusive (spheres contain possible overlap to other sections):
Group 1
Group 2
Group 3
Group 1 AND 2
Group 1 AND 3
Group 2 AND 3
Group 1 AND 2 AND 3
What I am struggling with is how to show the OR relationships:
Group 1 OR 2
Group 1 OR 3
Group 2 OR 3
Group (1 OR 2) AND Not 3
Group (1 OR 3) AND Not 2
Group (2 OR 3) AND Not 1
I have been researching different chart types but nothing is standing out as a good way to illustrate the data that represents OR relationships in data.
Any ideas would be great!!!
Bookmarks