2 Replies Latest reply on Dec 2, 2014 12:56 PM by Michel Caissie

    How to set a color for the chart for a value that doesn't yet appear on the chart?

    Lionel Yu

      I'm having the issue where I want to set the color "Red" to Red and "Green" to Green.  For the workbook attached, the calculated field "value color" will yield either Green or Red based on whether the value is under 3 or not.  Currently all of my values are over 3, therefore I can set the color of "Green" to Green (default is blue).  However, it does not let me set the color "Red" to Red until a value below 3 actually appears in the data set. 

       

      is there a way to adjust that color as well without there being currently data for that specific logic?

       

      Thanks!