+ Reply to Thread
Results 1 to 3 of 3

dividing and filling a circle

  1. #1
    ksmith
    Guest

    dividing and filling a circle

    I would like to divide a circle into 4 quadrants and have the ability fill in
    one quadrant at a time in order to show progress. Any ideas?

  2. #2
    Michael Glenn
    Guest

    RE: dividing and filling a circle

    Use three cells : Total work (A1), actual work (A2) and remaining work (A3)
    and then create a pie chart using the last two cells.

    Example

    A1: =100
    A2: =25
    A3: =A1-A2

    Create a pie chart graph using A2:A3 as the data

    If you only want quadrants, only use 0, 25, 50, 75 and 100 for Actual work
    (A2).


  3. #3
    ksmith
    Guest

    RE: dividing and filling a circle

    Michael, Thanks for your response. What I am looking at is a list of
    processes going along the row. Down the first column, I have names of
    associate. Each associate hasd a four quadrant cirlce for each process
    showing their competency at each process. I am going to end up with hundreds
    of these quadrants creating a visual representation of process skills by
    associate. Does this help?

    "Michael Glenn" wrote:

    > Use three cells : Total work (A1), actual work (A2) and remaining work (A3)
    > and then create a pie chart using the last two cells.
    >
    > Example
    >
    > A1: =100
    > A2: =25
    > A3: =A1-A2
    >
    > Create a pie chart graph using A2:A3 as the data
    >
    > If you only want quadrants, only use 0, 25, 50, 75 and 100 for Actual work
    > (A2).
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1