How to prevent Excel from creating a zero in a blank cell when referenced

Originally Posted by Tony Valko

Try this...

=IFERROR(1/(1/SUMIFS('Data Sheet'!$X:$X;'Data Sheet'!$BA:$BA;'YoY Content'!$A21;'Data Sheet'!$BB:$BB;'YoY Content'!H$18));"")

Hi Jonmo1 & Tony Valko

This worked for the cell i.e. the cell is now blank, but unfortunately the chart still shows the line in the bottom instead of just stopping after the last filled cell:

Capture1.PNG


Any way I could change that too that if the cell is empty no graph is drawn and as soon as the cell has a value the graph incorporates it?