Forum Discussion

bobbob123's avatar
bobbob123
Icon for Helper III rankHelper 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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Sorry but cannot help you with this.