12 Replies Latest reply on Mar 6, 2017 8:51 AM by Joe Oppelt

    Formula to create diverging color for line

    John Hobby

      Hey ya'll - I'm needing to create a colored bar from red - blue - green that starts at 0 (red) and goes to 100 (green).  This is on a dual axis with another value that represents an image on that line relative to the value.  For example the value is 55, an image will show on the line at 55.

       

      I have a simple calculation for 100 that i'm using to draw the line for the second axis, but i need it to go from red-blue-green.  There isn't any other value that related to making this line, so it's just a formula ... but i'm sure there is a better way to have this.

       

      Something like the image below ...Line Only.png

       

      Thanks in advance,

      John