How to change count to percentage in stack bar chart?

Bradhickswa

Hi SS Community,

I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA")

If it is a formula issue, what do I need to add/change about the formula so that the data shows as percentages and not counts?

Thank you!

-Brad

Paul Newcome

You would need to calculate the percentages via formula which would be the count of delivered divided by the total count:

=COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") / =COUNTIFS({X-Site Build Stage}, "POM to IHA")

Paul Newcome

You would need to calculate the percentages via formula which would be the count of delivered divided by the total count:

=COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") / =COUNTIFS({X-Site Build Stage}, "POM to IHA")