2 Replies Latest reply on Jul 10, 2017 2:03 AM by Antoine Chirac

    Color Legend to apply to several worksheets

    Antoine Chirac

      Hi everyone,

       

      Here is my problem : I'm creating a dashboard from OTRS data which is a ticket system. This dashboard contains 4 pie charts that are supposed to show the count of tickets for one queue in particular. The tickets can be in several states, and I'm supposed to represent every state :

       

      Capture.PNG

       

      Each pie chart is one worksheet. As you can see, I have a color legend for each chart. Right now it's only displaying the states that have non-zero values. For example, the state "open awaiting fix" only appears in charts 2 and 4. What I want is one legend that displays every state possible, because some states exist in one chart and not an other. Is there a way to force displaying all the states possible in one legend ?

       

      Thank you very much in advance.

       

      Antoine