Waterfall Chart NUX

MattDunne

I have a slightly unusual situation with the conditional formatting in one of our waterfall charts. Currently it is possible to select a conditional format for negative numbers and a different one for positive numbers. We have a situation where we are moving from a baseline to a target  and therefore negatives are good (formatted green). However, there is a final sum which shows "gap to target" which is effectively how much under or over the target they are. If they are under target this shows as a negative and therefore green, even though its actually a "bad" thing and should show as red. Conversely if they've met their target it then shows red....any one have any suggestions how this can be got around? 

 

Thanks

Matt

MattDunne

Hi Timmy, 

Thanks for this, will give that a go! 

 

Thanks

Matt