This is a discussion on Segented Circle in Excel Conditionally Formatted within the Excel Questions forums, part of the Question Forums category; Hi All, Is it possible in Excel to create a segmented circle with 28 equal segments and then from a ...
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....?
Welcome to the board
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
Maybe this article from Jon Peltier will help:
Conditional Formatting of Excel Charts | Peltier Tech Blog | Excel Charts
To understand recursion, you must understand recursion.