I have stacked bar chart, however I would like to convert it to a 100% stacked chart by adding another calculated category.

[Chirag Kapoor]

Hello,

I have a stacked bar chart, it shows percentage use of different resources in the same units. However, I would like to do some calculation which makes this stacked bar chat to a 100% stacked bar chart.

 

At the moment say the total of the 3 categories is 16 units. I would like to add another stack which shows 100-16=84. How do I add this calculated category. Any help is appreciated. Please refer to the screenshot to understand this better.

Cheers!

[foram merchant]

Can you please elaborate more to understand your requirement , May be if you can hand draw how exactly you need the barchart to look like and and dummy data file if possible !