A lot of time in your day to day work the requirement to create 100 % stacked column chart came. In this post we will see how we can create or plot 100 % stacked column chart in Tableau.
Data set –
First of all lets see the data that we are going to use for this simple example.
The above data contains marks of the students. The data set contains four columns namely ID, Name, Subjects, Marks and the percentage. Out of these the first four are easily understandable, the fifth is what we have calculated. As we have to create 100 percent stacked bar graph, we have to sum up the marks such that they can sum to 100 percent. Say for example, for John to calculate percentage, we divide each subject marks with the total he got for all subjects. i.e
Marks in English/ (marks in all subjects scored by John)
Tableau –
Now comes the chart preparation in Tableau. Once the data is ready, its easy to create chart. Drag and drop the Name into Columns and Percent in Rows. Also add the Subject column in Colors Marks, as shown below in the screenshot.
That’s it. The chart is ready.
To get more detailed knowledge about types of Charts, you can check the official Tableau website. Also if you want to explore more codes/posts related to same topic on our website, then you can find it here.
If you have any questions or if you need any help please get in touch with me using the comment section below.
Leave a Reply