6 Replies Latest reply: Jun 29, 2015 11:36 AM by Michael Palumbo RSS

    Conditional Coloring and Divided Legend

      I am having trouble conditionally formatting the colors within my chart to display red for values below zero and green for values above zero. My questions are as follows:

       

      1) My colors are displaying based on my conditional statement, however, I like the style 'Light Gradient.' However, I wish the green would display as the other colors, in a solid manner.

           ssss.png

      Example Chart

       

      2) I would also like a split legend icon that represent two potential values for a single expression. For example, profit margin. If margins are below zero, it should be colored rgb(255,0,0), else rgb(0,255,0). 

      split icon.png

      Example Split Legend Icon

       

      Thanks in advance to any and all help!