2 Replies Latest reply on Mar 29, 2016 12:12 PM by Ashwin Chandak

    Conditional Formatting Based on Calculated Field

    Ashwin Chandak

      Hello,

       

      I am trying to color code/conditionally format a line chart based on a calculated field.

       

      I drag the score on rows and date on columns, and add the calculated field on the color section.

       

      The line chart now gets split according to color (I get three line charts based on the 3 colors I added)

       

      Please find a sample workbook attached.

       

       

      I need to have all colors showing on the same line chart.

       

      Is there any way I can do this?

       

      Thanks.