how to show particular values by red dots in line chart ??

[nikhilgarg]

Hey,

I have a line chart. In that i want the values that goes above 102 and below 98 should be shown by red dot. How can i do that??

Please tell em the expression.

My expressionj is :  Sum(Price)/Count(Price)

Thanks

[#2]

Dear Nikhil,

Click on + sign in front of expression and click on Background Color option and use expression:-

if(sum([Sum(Price)/Count(Price))>98 and sum([Sum(Price)/Count(Price))<102 ,red(),green())

Thanks & Regards

Prince Anand

[nikhilgarg]

HEy,

I ahve used following exp:

=if(Sum(Price)/Count(Price) > 101 , RGB(255,0,0),

if(Sum(Price)/Count(Price) <99 , RGB(187,244,84)))

But it is making some portion of line as green or red depending on values but i want only values shown by intersection point to be colored red or green only. How can i do this??

[DavidFoster1]

You can just colour the dots themselves. You could colour the label only so that the value text is the colour you want by applying the same if statement to the font colour instead of the background colour.

If you absolutely have to have the colouring as you want it then you need to look at writing your own extension. Good luck with that.