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
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
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
What's a helper column?
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)
Thanks again.
forum pic 6.png
Happy to help and thanks for the feedback
Really nice looking dashboard, too, thanks for sharing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks