Results 1 to 2 of 2

Segented Circle in Excel Conditionally Formatted

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

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    1

    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,761

    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.

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