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?

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?

Hi,

Use NA() instead of zero in your formulas. It will stop the dipping and
interpolate between points instead.
Why do you want to hide zero values?

Cheers
Andy

Typical Village Idut wrote:
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?

Thanks you to both of you....I have a need to use ISERROR to hide the
division error caused by missing data on another worksheet. I used it to
display a blank cell where approriate to maintain a clean appearance on my
worksheet. By using the NA(), I can reference the cells by IF statement and
then chart the data. I now can simply hide the row with the #N/A and
maintain the clean appearance. Thanks again for your help.

"Andy Pope" wrote:

Hi,

Use NA() instead of zero in your formulas. It will stop the dipping and
interpolate between points instead.
Why do you want to hide zero values?

Cheers
Andy

Typical Village Idut wrote:
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?