Aug 11 2020 05:14 AM - edited Aug 12 2020 02:22 AM
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 I have from each color- how do I do that?
Instead of doing a sum if to get the total from each column
Thanks in advance!
Aug 11 2020 10:22 AM
I do not understand your chart. The colors go across, what do the combo-colors that go down represent? Also, based on the marking you have, what percent does each color have that would be represented by the pie chart?
Aug 11 2020 10:25 AM
Aug 11 2020 10:42 AM
Aug 12 2020 02:24 AM
I will try to explain better- I need to do a count if on each color on a pivot table for each color and unify all these sums of colors. The total will be the amount of Y I have
Aug 12 2020 05:08 AM
I do not understand the need for a pivot table for such a small amount of information. You originally requested a pie chart with percentages. My first answer met that requirement so please explain.
Aug 12 2020 05:21 AM
Hi, eventually I want to have the relative amount per color (sum if per color) that has Y in this pie (count if)
Amount/color | Blue | Red | Green |
5 | Y | Y | |
20 | Y | ||
6 | Y | ||
sum 31 | |||
Count if | 1 | 2 | 1 |
sum if blue | 5 | 0 | 0 |
sum if red | 0 | 25 | 0 |
sum if green | 0 | 0 | 6 |
Aug 12 2020 05:48 AM
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?
Aug 12 2020 05:59 AM - edited Aug 12 2020 06:00 AM
Hi,
In my actual charts I have something like 5 categories (which are colors here) and 50 rows. The amount is a number that represents time, so my goal is to know how much time we invested per category aka color
Thanks,
Moran
Aug 12 2020 06:05 AM
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.