Creating Pie Chart with Non-numeric values
I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I look at the pie chart, I might see 25 green, 13 red, and 7 yellow (representing issues that we're working on or have completed.)
Any thoughts on how to make this work?
Help Article Resources
Check out the Formula Handbook template!