+ Reply to Thread
Results 1 to 2 of 2

Chart Group Data Combinations?

  1. #1
    Registered User
    Join Date
    09-10-2004
    Posts
    18

    Chart Group Data Combinations?

    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!!!

  2. #2
    Registered User
    Join Date
    07-15-2010
    Location
    California, United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Chart Group Data Combinations?

    What is the difference between "Group 1" and "Group 1 Only" and with "Group 1 OR 2" and "Group (1 OR 2) AND Not 3"?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1