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 ...
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)
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)