Noob Needs Help Creating a Graph from Non-numerical Data

Hello,

Firstly, I'm a long time lurker and this forum has helped me on previous Excel needs. Unfortunately I was not able to find my answer using the search function, so I am here asking for help from the Excel gurus!

I have a graph with three columns. Column 1 has two categories. Column 2 has six categories that are "outcome" columns. Column 3 has nine categories that are "activity" columns. I'm trying to make three graphs, one using one category from column one, another using the other category from column one, and a third comparing the outcomes and activities from the two categories of column 1.

IE - For Dogs or Cats (Column 1) it is Dangerous, Safe, Potentially Dangerous, Potentially Safe, etc. (Column 2) to Eat Chocolate, Play Fetch, Scratch Someone, etc. (Column 3). So there are essentially 300+ combinations that I need to graph on whether or not it's more risky to play as a dog or cat.

Edit - Here is the graph.

Please let me know if you need more clarification.

Thanks!

Have you tried putting the data into a pivot table? You can add non-numeric fields as values and it will count the number of records per category. This should allow you to easily spot the differences between your subjects and outcomes in each group. You can also apply conditional formatting to highlight whichever is greater.

nonnumeric.png