Are you able to unpivot your data?
So that instead of this
User Q1 Q2 Q3 John 1 2 4 Bill 3 5 2 Jane 4 4 5
it looks something like
User Question Score John Q1 1 John Q2 2 John Q3 4 Bill Q1 3 Bill Q2 5 etc...
If you can, then the task becomes piece of cake. Tableau have a tool to automatically unpivot data in Excel, see
If you cannot change the structure of the data, then it is a big headache. I tried and failed because in custom calculations there is no way to identify the column name, i.e. which question the score relates to.
There is a very nice example of this in action on Andrew Marritt's site. Go to
There is a possible tweak to this view that someone may want to take on. That is: how might you best handle the neutral responses in such a survey while still preserving this elegant way of visualising the data?
It always seems strange to leave out data if you don't have to....
net_stacked_distribution.twbx 14.8 KB
I've been grappling with this issue for years and, inspired by a Stephen Few example, wrote a blog post with accompanying Tableau workbook on different approaches to presenting Likert data. Have a look at http://www.datarevelations.com/the-likert-question-question.html when you get a chance.