Hi Shona,

Try using the NA() formula instead of zero or ""

Cheers
Andy

SS wrote:
Hi

I want to plot a chart but it not to show the values if the value of the
formula is zero even though they are ranged.

Is there anyway this can be done?

Cheers
Shona



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info