Skip to main content

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:

 

Comprehensive Legend

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:

pastedImage_1.png

 

but with the absence of values greater than 10% i am only going to get this:

 

pastedImage_2.png

 

Any one have an idea on how I might be able to do this?

 

Thank you,

 

Scott

2 respuestas
  1. 1 ago 2019, 17:29

    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

0/9000