Circular Table or Chart in Excel

Danny318

New Member
Joined
Jun 19, 2007
Messages
40
1599767536548.png
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!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,335
Messages
5,624,090
Members
416,010
Latest member
NJT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top