Pillar Bar Chart

Article summary

Did you find this summary helpful?

Thank you for your feedback

Very Importnat Note

No dataset filed will be in double quotes

Go to bar chart & see How to Create a Bar Chart in order to get reference of creating Pillar Bar Chart
Please go through Source Data for more understanding on what Pillar Name and Other terms used below are.
Rename your chart as "ScorecardName_Pillar_Bar_Chart" ScorecardName will be replaced by your actual scorecard name.
Three main chart properties that we have to focus on are -
a) Label, b) Legend & c) Dataset_Field
Go to the Source Data Sheet there you can find "Pillar Name" row which will consist of multiple Pillar name. This is explained in point 2.
Number of Rows in Chart rows & column section will be equal to as Pillar Name we have in our Source Data Sheet.
Add number of rows using "+" sign in Chart rows & column section.
Add all the "Legend" with Pillar Name.

Important note

Make sure Legend is between ""(double quotes)

Add Name in the Label of col 1 for each row. This way you can see company name in the chart.

Important note

Name used above is the dataset field
The Name here is dataset field it will not be in ""(double quotes).

Add Dataset_Field with the data you need which is there in the Dataset, it will be Calculated Pillar Percentage.
Replace color with #681c4c for all rows.

Important note

Make sure you fill all the rows, columns and then save the row else it will throw an error.

Was this article helpful?