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 ,


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.

  • bobbob123's avatar
    bobbob123
    Helper III
    4 years ago

    but this is not a solution to my problem. the final graph is not an accurate representation of my original graph.