I am using the formula =IF(A4,SUM(C$4:C4)/A4,NA()). I am using NA() instead of "" so my charts won't plot zero's when the formula results to NA().
However this displays #N/A in the cells which doesn't look very good. I am trying to use conditional formatting to change the font colour to white but the # is preventing it from working.
Does anyone know how to overcome this or another way to do it so my charts don't plot zero values?
Bookmarks