Bernard Liengme wrote:
Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes

I tried something like this and it didn't work. I finally had to just
remove the values, leaving a blank cell.