Hello together,
does somebody know how to remove zero values from a bubble chart?



I took a whole table as data range. Within this table, there are also columns with "O" for X and Y value in it. Therefore, my bubble chart shows several bubbles at (0/0) which are all overlapping each other.

Now, I would like to find a solution how to remove those bubbles in (0/0) but unfortunately, I didn't make it to find a solution yet.

Does anyone know? Thank you all so much!

Replace zero value with "#NA" [e.g. using IF()] - the graph line will have gap then instead going to 0. But I'm not sure about bubble charts, I have used this with line graphs only!