Forum Discussion
How To Create a Gauge-Style Doughnut Chart that Includes Negative Numbers & Greater than 100% Values
ntlknight Not exactly what you had in mind with regard to the vivid colours, but close. See attached.
The driving force sits out of view below the chart.
Riny_van_Eekelen Well, for not being crazy about doughnut charts, you sure are good at editing them and figuring out how they work! I'm amazed, it's perfect! I read, re-read and then read 2 more times your last post...and I still have a hard time wrapping my head around it! I didn't know you could separate the slices like that (rather than superimposing (duplicating) one doughnut chart on top of another one).
There is one thing I don't know how I missed before...if the "Actual" cell contains a 0, or is blank, the inner gauge ("Target") doesn't retain its half-circle shape, but rather makes a full circle. This will cause a confusing look to the Sheet, as there will be one of these gauges for each day of the month...and until the day is approached, all the upcoming/future days will be 0. Is there a way to have the inner (Target) slice keep its half-circle shape even when a 0 or blank is in the "Actual" field?
Much appreciated,
Nathan
ntlknight Aha! didn't think of that. Change the formula in C7 to:
=IF(C4,C6*SIGN(C4),C6)That should fix it.
- Worked like a charm. Thank you so much! I think that's it...for this "dream gauge" that you helped me create! I'll follow-up with you in a few weeks as I populate the month's progress and show you how this operates in real time!
Best Regards,
Nathan
