Forum Discussion
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 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!
9 Replies
- So assuming the 2nd Y under the Blue column should be under the White column, that would give us 5 total "Y's". Blue, White, Green, would each have 1, Red would have 2, Somewhere underneath the Green ROW (I will use row 5 in my example) create a formula to count the "Y" characters in the color columns.
Assuming "Labels" is in cell A1, in B5 write:
=countif(b2:d2,"Y") drag this formula across to the green column to copy to cell E5. Now select all four cells that do the counting (cells B5-E5) then go to the INSERT tab at the top of excel and find the Recommended Charts area, and select the pie chart. You can format it from there, including making the color in the pie match the entry. (Your charts may be elsewhere in the ribbon. Search for them) - Should the second entry have a Y under the "White" header instead of the Blue header, making it Red;White?
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?
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
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.
