+ Reply to Thread
Results 1 to 3 of 3

Show degrees on a pie and/or clock

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Encino, CA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Show degrees on a pie and/or clock

    Simply put I just need to show a pie chart representation whatever degrees are in the corresponding cell.

    For example, if A1 says 90, I want a pie chart that would show a 90 degree piece of pie in the upper right of the pie (12 and 3 o'clock positions)

    Then for 180 it would be divided in have etc.

    So I need a pie that represents only one cell of data which in this case is degrees.

    It seems to me that should should be simply?

    DB

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Show degrees on a pie and/or clock

    Suppose you put your degrees in B2, then you can put this formula in B3:

    =360-B2

    and then use these two cells for your pie chart (you can change the colours of the second slice to white).

    Hope this helps.

    Pete

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Show degrees on a pie and/or clock

    File attached to demonstrate.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ 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