Segented Circle in Excel Conditionally Formatted

nigo75

New Member
Joined
May 28, 2013
Messages
1
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....?
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,771
Hi
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,803
Messages
5,446,560
Members
405,407
Latest member
apat

This Week's Hot Topics

Top