Hi All,
Is it possible in Excel to create a segmented circle with 28 equal segments and then from a table conditional format to say "RED" for "NO" and "GREEN" for "YES" for each segment....?
There are several approaches to the problem, using charts or shapes, and formulas or vba.
The way I'd choose is to use a conditional formatted chart.
I would do it the following way.
1 - use a scatter chart to draw the circle. I would test to determine the number of points per segment. I guess 10 points are enough, but maybe for a very big circle you could use 20 or 100. Just try with 10 and if you still think it's not round enough add more
2 - split the series in 2, one series with the segments that correspond to the Yes and the other with the other segments
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.