Vba suppress screen updating
Unfortunately Excel has no formulaic way to simulate a blank in a cell.
In a formula, the function NA() returns this error.
For these chart types it would be better to use “” or even zero, and apply a custom number format that suppresses the display of zeros (a format like “0;-0;;”).
A pie chart will behave like a column or area chart: there is no visible point (wedge) but there is a data label showing zero or #N/A where the wedge would be located.
These charts use “” in a logical yet misguided attempt to simulate an empty cell.
All charts plunge to zero, and all display a data label showing the value zero.