How do I create a chart with an or filter

Hi, I have this table Labels Blue Red White Green Blue;Red Y Y Red;White Y Y Green Y I want to have a pie chart that will say the percentage ...

Brass Contributor

Aug 12, 2020

Ok, i get it. Is this chart the biggest it will be or is this the total size?

And to be sure, you are wanting formulas for the Sumif red, blue and green, in each column?

Brass Contributor

Aug 12, 2020

I placed your chart starting with cell A1.

In cell A5 put ="sum "&SUM(A2:A4)

"Sumif blue" is in A7. In B7 put =SUM(IF(B2="Y",$A2,0)+IF(B3="Y",$A3,0)+IF(B4="y",$A4,0))

"Sumif red" is in A8. In C8 put =SUM(IF(C3="Y",$A3,0)+IF(C4="Y",$A4,0)+IF(C5="y",$A5,0))

"Sumif green" is in A9. in D9 put =SUM(IF(D4="Y",$A4,0)+IF(D5="Y",$A5,0)+IF(D6="y",$A6,0))

All the other cells in the sumif range are just 0.

You can change the values in A2, A3, A4 to any number you wish and it will still add them correctly.

Forum Discussion