Replace the blanks by NA() which displays as #N/A.
These values are ignored by the Excel chart engine
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Typical Village Idut" wrote
in message ...
I have data I would like to chart in a line graph. Is there a way to
display
a line graph and prevent the line dipping to zero for zeros? I've tried
to
no avail to reference or convert zeros as a blank cell as the chart will
not
consider the blank as a point on the graph line. I've yet to find a
formula
to allow this. Suggestions?