Hi,
So, I have a large dataset with survey responses. Among them are multiple choice responses:
I'd like to add them to a pivot table with chart, displaying them like this:
Unfortunately, I can't find a way to do this. The closest I get is this:
Obviously, that isn't the way to go as I can't insert a decent chart that way
So, I have a large dataset with survey responses. Among them are multiple choice responses:

I'd like to add them to a pivot table with chart, displaying them like this:

Unfortunately, I can't find a way to do this. The closest I get is this:

Obviously, that isn't the way to go as I can't insert a decent chart that way

Last edited: