Segented Circle in Excel Conditionally Formatted

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Segented Circle in Excel Conditionally Formatted

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Segented Circle in Excel Conditionally Formatted

     
    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....?

  2. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,955
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Segented Circle in Excel Conditionally Formatted

      
    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
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com