If you still want help, you may need to make it clearer how your NULL values
appear.
--
David Biddulph

"Pietro" wrote in message
...
I don't have any formula like this ,but the cells that combine the the data
source of the chart are linked to other cells in other tab,and these ones
as
well don't have this formula..

"David Biddulph" wrote:

If you have a formula that currently says =IF(A1=0,"",A1), then replace
this
by =IF(A1=0,NA(),A1).

"Pietro" wrote in message
...
Could you please more clear ?

"David Biddulph" wrote:

Replace your NULL by =NA().

"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if
the
value entered in the source data is NULL,the chart displays it as if
it
were
0,i tried to change the frormat of the source data cells to number
or
general,but i always get the same result..can anybody help ???