+ Reply to Thread
Results 1 to 9 of 9

How to stop 115% going over 100% in doughnut chat?

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    How to stop 115% going over 100% in doughnut chat?

    Hello, how to stop 115% going over 100% in doughnut chart? I have 75% going 75% over the doughnut but when I have 115% for example it goes back to 85%. Here is a picture and a template.

    forum help 5 pic.png
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to stop 115% going over 100% in doughnut chat?

    Use a helper column (say C) and refer to that for the chart.

    Then put this in B8...
    =max(B8,1)
    and in B9, you dont need this...
    =SUM(100%-B8)
    jjst use this...
    =100%-B8

    You only need to use SUM if you are adding a range of numbers/cellsa
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to stop 115% going over 100% in doughnut chat?

    Quote Originally Posted by FDibbins View Post
    Use a helper column (say C) and refer to that for the chart.

    Then put this in B8...
    =max(B8,1)
    and in B9, you dont need this...
    =SUM(100%-B8)
    jjst use this...
    =100%-B8

    You only need to use SUM if you are adding a range of numbers/cellsa
    I don't understand it. Can you please upload it?

  4. #4
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to stop 115% going over 100% in doughnut chat?

    What's a helper column?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to stop 115% going over 100% in doughnut chat?

    A helper column is just that - a column (or cell/s) that you use to "help" you get what you need. Look at column C in the attached (your actual data is in B)
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to stop 115% going over 100% in doughnut chat?

    Quote Originally Posted by FDibbins View Post
    A helper column is just that - a column (or cell/s) that you use to "help" you get what you need. Look at column C in the attached (your actual data is in B)
    It works thanks!

  7. #7
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to stop 115% going over 100% in doughnut chat?

    Thanks again.

    forum pic 6.png

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to stop 115% going over 100% in doughnut chat?

    Happy to help and thanks for the feedback

    Really nice looking dashboard, too, thanks for sharing

  9. #9
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to stop 115% going over 100% in doughnut chat?

    Quote Originally Posted by FDibbins View Post
    Happy to help and thanks for the feedback

    Really nice looking dashboard, too, thanks for sharing
    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Doughnut Pie chart
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2016, 04:23 PM
  2. Chat Room
    By Workle in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-10-2015, 09:22 AM
  3. Help with Doughnut graph
    By chrisleppard in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-23-2015, 09:09 AM
  4. Live chat/chat room
    By SChapman in forum Suggestions for Improvement
    Replies: 1
    Last Post: 05-06-2013, 10:05 PM
  5. Doughnut chart
    By TomBP in forum Access Tables & Databases
    Replies: 8
    Last Post: 02-19-2011, 09:46 AM
  6. Chat?
    By Chappo in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 4
    Last Post: 10-03-2006, 11:01 AM
  7. [SOLVED] Can one use excel like a chat
    By Christopher Sequeira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2005, 07:05 PM

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