Jim, thank you for your anwer. I have this:

And I would like to have all this bars side by side. But I want each bar to remain vertical.

Does that make sense?

Thank you!

Hi Jim, thanks again for taking the time to answer. However, unfortunately it is not that simple.

Here is a sample of my database.

Context: clients were asked which activity they prefer. They were supposed to rank their top-5 preferences. The numbers in the database are the rank position of each activity that each client have chosen. since they could rank only 5 activities and there are more than 20 activities, some activities do not get ranked for a given client.

My goal: For each activity, I want to have a stack graph, with the total number of mentions and with the percentage of rank positions (illustrative example: Activity A mentioned 30 times, being: 20% of times ranked as 1st option, 40% of the times ranked as 2nd option, etc).

I have managed to build the stacks for each activity, however, they appear as I showed in the picture that I have shared before. And I want the stacks to be side by side.

Does that make sense?

Hi, sure, please if you can check the data below in my reply to Jim, it would be great. Thanks

Yes, I do have Alteryx and Excel and could transform my data.

I will add this chart as part of an interactive dashboard, this is why I was trying to do everything on Tableau, because I want to se demographic information of clients as filters.

If I transform the data outside of Tableau into a table ready to plot this output format on Tableau, I am afraid I will loose the flexibility of interacting on my dashboard.

Thanks