Trying to make a chart like this that i can change colors to green, yellow, red depending on if daily goal was reached, almost completed, not completed. The 31 sections of the chart will represent days of the month 1-31. The colors should change based on the data I put in cells G=green, Y=Yellow, R=Red. The charts I'm finding want to change the size of the segments based on value but I don't want that. I was thinking of a circular table or something with conditional formatting. Help is greatly appreciated!
What you need are not 31 but 93 donut segments, one of each color for the 31 days. For each triad, the data value will be 1 for the desired color and 0 for the other two, so the sum of all 93 points will be 31. The points with value 1 will appear, those with value 0 will not appear. It takes a whole lot of formulas to set these values to 0 or 1, based on the desired colors for the days.