2 Replies Latest reply: Jun 4, 2018 11:09 AM by M P RSS

    How do I change color of data points based on criteria?

    M P

      Hi,

       

      Given this data:

       

      Customer

      MonthSaleExperience
      CustomerA

      1

      25Negative
      CustomerA215Positive
      CustomerA318Positive
      CustomerB114Positive
      CustomerB216Negative
      CustomerB310Positive

       

      I would like to create a line graph with Month on the x-axis, Sale on the y-axis, and Experience determining the color of the data point (red for Negative; green for Positive). Is that possible and if so, how?

       

      Less important, but would it also be possible to have the above with lines for both subjects displaying? I'm know how to get both subjects displaying with Sale by Month, but I need to have Experience visible as well and I will settle for getting Experience data in with only one subject visible at a time.

       

      Thanks in advance!