I need to show Negative numbers as a Zero for Forecast Chart

[TonyT]

Hi, I am trying to make a chart that shows Actual savings against Forecast savings, the calculated cells I am using for my data is showing a negative when I need it to show a zero (0) for the months with no savings in yet.

I need the chart to look like this with nothing resulting in the variance column so there are no negative values in the chart

I have almost fried my brain trying everything!!

Thanks

 

[Gasman]

How about an IF() function?

 

[cheekybuddha]

Try either:
=IF((Actual-forecast) > 0, Actual-forecast, 0)
Or:
=MAX(Actual-forecast, 0)