Chart Not hiding 0 Values even after NA() formulae applied

[gogeta1999]

Hello,

I've been trying to get a line chart to hide 0 values.
I've tried forcing the formulae to make a blank cell and for a NA() but the chart still connects 0 values.- (Please see video link below)
Any help on how to solve this would be hugely appreciated

https://www.hippovideo.io/video/play/2HajYx8xOkY-Mjq8FEXybw==

Thanks
Kind regards,
g1999

 

[oldbrewer]

where are the 0 values coming from - if a formula make them NA() right from the start

 

[gogeta1999]

where are the 0 values coming from - if a formula make them NA() right from the start

Thanks for the response, is there no other method of achieving the result without forcing NA() from the source. The source tab has quite afew analysis linked to it so forcing an NA() on the source would cause NA() values to crop up all over the spreadsheet.

I think I'll have to make a new source tab for these graphs with the same data loaded in

 

[oldbrewer]

make steet2!A1 = sheet1!A1 and copy across and down then in sheet3 =if(sheet2!A1=0,na(),A1)