Stacked Bar Chart with Percentages

Sophie Knudson

Hi Paul,

I'm cell linking each of the country percentages from a larger sheet. I just wanted to pull out the milestones here so I could make a chart with only the "need-to-know" info rather than everything.

In the source sheet the column is formatted for percentages.

Thanks again for your help!

Paul Newcome

My apologies. I used the SUMIFS syntax n the COUNTIFS. Try this...

=(COUNTIFS([Burkina Faso % Complete]@row:[PAHO % Complete]@row, @cell <> "") -1) -SUMIFS([Burkina Faso % Complete]@row:[PAHO % Complete]@row, [Burkina Faso % Complete]@row:[PAHO % Complete]@row, @cell <> "")

Sophie Knudson

Hi Paul,

This time the formula worked, but its giving me weird percentages for the other milestones.

Any suggestions to fix this?

Paul Newcome

Lets give this a whirl...

=SUMIFS([Burkina Faso % Complete]@row:[PAHO % Complete]@row, [Burkina Faso % Complete]@row:[PAHO % Complete]@row, @cell <> "") / COUNTIFS([Burkina Faso % Complete]@row:[PAHO % Complete]@row, @cell <> "")

Sophie Knudson

That solved it! I ended up just making my bar chart reflect the average, rather than all the pieces adding up to the average in a stacked way. But this was really helpful! Thank you!

Paul Newcome

Happy to help. 👍️