Forum Discussion

bobbob123's avatar
bobbob123
Helper III
4 years ago
Solved

Conditionally Format Area Chart

Hi,   I would like to condtionally format my area chart.  I have a profit, area and year column. I would like format the chart so that if the profit value is below 0, then the chart is red. If it ...
Need Help
Show and Tell
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi bobbob123 ,


    It seems a bit odd, but the best way to display it would be as follows.

    M1 = IF([M_value]<0,[M_value],0)
    M2 = IF([M_value]>0,[M_value],0)

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi bobbob123 ,

 

That's pretty good. You can follow the steps in the video to get the results you want.

 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry

 

bobbob123's avatar
bobbob123
Helper III
4 years ago

I coulnd't replicate the video 😞 

 

This is why I need help!