Lately I having a problem trying to remember how to do this. I know it is simple but just need some guidance.
I have a data set similar to this.
What I want to do is create a chart out of columns D, E and F
I need to have on the horizontal access how many times the item occurs such if you select all rows you will see Scooby_Doo appears twice but once under column D and once under Column F.
So horizontal access who have the major labels of TVShow1, TVShow2, and TVShow3.
Sub axis would be one for each of the pieces of data in the column and the data would be the count of how many times appears.
For example the first set of bars would be for TVShow1. There would be five bars with values Category A (2), Category B (4), Category C (1), Scooby_Doo(1) and Jetsons(1). Yes we have to parse the or statement.