Try selecting the chart (just click on it) ; use Tools|Option|Chart and set
required option in Plotting Empty Cells box
best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JC" wrote in message
...
Hi,

I have several different charts running, both dynamic and static, and both
types
have the same problem.

Amongst the data being plotted are cells with computed values using
formulas
similar to =IF($B70,AVERAGE($B1:$B7),""). The line graphs are drawn
ok
where there is real data present but at the first point where the "" is to
be
graphed the line drops to 0. Subsequent points are not plotted but
presumably
would be if 0 was included in the graphing range. I assume that this
happens
because Excel treats text as being zero.

I have tried replacing the "" with NA() but this puts #NA in the workbook
cells
and doesn't change the way the graph is presented. If NA() had worked I
would
have left the cells on screen with "" as information cells and set up
helper
cells off screen with NA() replacing "" purely to be used for the chart.

This is not a big problem and I can live with it as it is now but It would
be
better if the graph stopped at the last entry with real data.

Is there a way to achieve this?
--

Cheers . . . JC