Creating Pie Chart with Non-numeric values

kjthacker

Hi,

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?

Thanks!

JVaihinger

Easiest way for you to track and report that data easily would be for you to create a "Summary" or "Reporting" section at the top of the sheet with the bugs, then add a line for each of the items you are looking to track, with a COUNTIF for each of them. =COUNTIF(Status7:Status50, "Red"). You can then pull all of this data easily into your reporting

 

kjthacker

Many thanks, @JVaihinger.