Thanks for the reply John, but none of those work for me...........I
couldn't get either the first or third ones to work at all and I percieve
that I would have to put code in every chart sheet for the second method to
work and I have too many to do that..........

I do appreciate you trying tho........thanks again,

Vaya con Dios,
Chuck, CABGx3



"John Mansfield" wrote in message
...
CLR,

These three resources should help:

From Tushar Mehta:

(1) http://www.tushar-mehta.com/excel/so...discontinuity/

(2)

http://groups-beta.google.com/group/...rting/msg/31cc
a276cbd4877b

From Andy Pope:

(3) http://www.andypope.info/charts/brokenlines.htm

----
Regards,
John Mansfield
http://www.pdbook.com



"CLR" wrote:

Hi All......

I have a Line Chart wherein all cells in my source data that are blank,
( as
result of a formula resulting in ""), all plot as ZERO, and I would like
them
to just be nothing, not charted.......I do not want them interpolated
and the
one before and the one after just joined......I do not want NA in the
cells
because I use them for other formulas.........I go to Tools Options
Chart
tab, and no matter which option I select under "Plot empty cells as", I
STILL
get them plotted as ZERO's......

The only way I've been able to get them to plot correctly is to actually
copy a "real" blank cell over to it......is this the only way, please?

TIA
Vaya con Dios,
Chuck, CABGx3