Thank you very much, this indeed works.
Just a pity as far as aesthetics are concerned.

Best regards, Bernd






On Thu, 25 Jan 2007, Roger Govier wrote:

Hi

Try using NA() instead
=if(I4=0,NA(),I4)

The chart will not treat the #N/A resulting output as a zero value

--
Regards

Roger Govier


"Bernd Pollermann" wrote in message
.ch...


Hallo,

My aim is to have gaps in a chart when a cell is empty.
So, what I did was the following:

In the column to be plotted (E) I put the formula:

=if(I4=0,"",I4)
=if(I5=0,"",I5)
=if(I6=0,"",I6)

(in column 'I' I have my data, which as of a certain row
are 0, and which I don't want to see in the chart)
As a consequnce the cells in columns 'E' do look empty
if the content in columns 'I' is 0.


I then clicked on my chart and went to Tools - Options - Chart and
selected the option

Plot empty cells as: * Not plotted (leave gaps)

and clicked OK, in other words I followed to the letter the
directives in Excel (I am using Excel 2003 from Windows XP).


Despite these efforts, the empty cells are plotted as zero-values.

Any ideas of what I can do to create empty cells which are
"respected: by the chart?

Best regards, Bernd

Ps. In case I "delete" the content of the cell manually
I get the gap in the chart. This seems to suggest that
the "" in my if-formula does not produces really an empty cell
as far as the chart goes.