Hello,
Ok so I have a viz that has many different doughnut charts that tell a manager how much money they have spent versus how much they have left. Looks like this:
Because I have multiple funds, I have multiple doughnut charts. The coloring of the doughnut charts is the same, regardless of the fund.
So if the difference is:
1%-3% then green or "on target"
4% - 10% then yellow or "near target"
More than 10% then red or "outside of range"
What I want to do is to show a legend with all three colors. For the sake of the argument - let's say there are no values greater than 10% so everyone is "on target" or "near target"
In other words what I want to show is this:
but with the absence of values greater than 10% i am only going to get this:
Any one have an idea on how I might be able to do this?
Thank you,
Scott
Hi Scott,
If you create a separate worksheet for your legend you can float it on your dashboard to make it look like it's the default legend. This article from Ken Flerlage explains a variety of methods for handling custom legends. Pay attention to how he sets up legends on separate worksheets.
https://www.kenflerlage.com/2019/06/legends.html
Best,Paul