Creating Pie Chart with Non-numeric values

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!

Find more posts tagged with

Formulas

Project Management

Comments

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

Summary Section.JPG

Summary Dashboard - Bugs.JPG

kjthacker

Many thanks, @JVaihinger.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…