5 Replies Latest reply: Mar 23, 2018 9:55 PM by Anil Samineni RSS

    Pie Chart Colors

    Mike Sawyer

      Good Afternoon,

       

      I use the following expression to try to use my own colors in a pie chart ("Custom Colors", "By Expression"):

       

      If ([GR Status] = 'Not Growth Ready', LightRed(),

      If ([GR Status] = 'Growth Ready', LightGreen(),

      If ([GR Status] = 'Potentially Growth Ready', Yellow())))

       

      This doesn't work in changing the colors of the 3 slices, all 3 pie slices are gray....

       

       

      Why isn't this working properly?

       

      Thanks much!