Conditionally formatting doughnut chart based on non-percentage value

[Pi_Lover]

How do I conditionally format a doughnut chart based on a value that is not a percentage? Chart will remain at 100%, but I want the color to change based on a specific number value. Such as <=1 is green, >1 and <=1.5 is yellow, and >1.5 is red. Is this possible to do?

 

[kevin9999]

I don't quite understand what you want. In your image, there is only one value in the table showing 1 - which is for <1 (green) and no other value in any other range therefore there should just be a single donut at 100% for green. I don't understand what you mean when you say change to a 'segmented' donut chart. Do you mean that when another value is in your table as well as the one shown, that 2 different 'segments' should be showing on your chart? If so, doesn't post #2 suggestion do that?

 

[Pi_Lover]

A segmented chart is the chart is divided up into segments. Like my charts in the picture, it is 2 doughnut charts with 20 individual segments, each at 5 degrees. Just an added "cool" factor.

The problem is that when the variable changes to show 1 for green, the yellow chart should reduce to zero. The green chart will always remain at 100%, with the yellow and red overlayed over it. So that when the value changes to the desired number, 1.1 through 1.5 for yellow, the yellow chart goes to 100%, and the same for red, 1.6 or >

 

[kevin9999]

Could you share your file, the one that produced the image in post #10, via Google Drive, Dropbox or similar file sharing platform?

 

[Pi_Lover]

Could you share your file, the one that produced the image in post #10, via Google Drive, Dropbox or similar file sharing platform?

I just started a Dropbox account. How do I share it with you?

 

[kevin9999]

How to share a Dropbox file or folder

 

[Pi_Lover]

Multi Layered Doughtnut Chart.xlsx

Shared with Dropbox

www.dropbox.com

 

[kevin9999]

I can't reproduce the 'segmented' appearance of your charts, however, the visible/invisible aspect works for me as I understand the way you want it. Link to the file here: Loading Google Sheets

This is what it looks like for me:

 

[Pi_Lover]

I can't reproduce the 'segmented' appearance of your charts, however, the visible/invisible aspect works for me as I understand the way you want it. Link to the file here: Loading Google Sheets

This is what it looks like for me:
View attachment 102471View attachment 102472View attachment 102473

Check out how to make them here

series doughnut charts excel - Search Videos

www.bing.com

 

[kevin9999]

Thanks for that - I see what you mean now. It's as if the series 'resets' itself after every time the source data drops to zero. Unfortunately, after much experimentation, I can't find a way to overcome this. You may be stuck with non-segmented donut charts, or alternatively, another volunteer may come up with a way around the issue. Best of luck!