Circular Table or Chart in Excel

[Danny318]

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!

 

[Jon Peltier]

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.

I should write it up on my blog.