View Source

This article explains how to create a 100% stacked column chart, which is a standard chart type in Data Studio.

Syensqo IS - Customer Support > Create a 100% stacked column chart > image2021-11-2_23-41-22.png

In our case we want to plot on the x-axis the inspections types and on the y-axis a stacked column bar counting how many anomalies were found per each type of inspection.

Step-by-step guide

Create a stacked column bar chart

Syensqo IS - Customer Support > Create a 100% stacked column chart > image2021-11-2_22-34-50.png

Select the desired x and y axis dimensions and color the bars by the Anomalia column (the dimension you wish to stack)

Syensqo IS - Customer Support > Create a 100% stacked column chart > image2021-11-2_23-42-19.png

In order to have a stacked 100% chart change the aggegation type to count and set the trend and comparison field to % of your x -axis

In order to display the values inside the bar, right-click on the chart area and select Plot properties. Go to the Options tab and check the Show values option

Syensqo IS - Customer Support > Create a 100% stacked column chart > image2021-11-2_23-53-2.png