Charting zeros as non zeros

[Guest]

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?

 

[Bernard Liengme]

Replace the blanks by NA() which displays as #N/A.
These values are ignored by the Excel chart engine
best wishes

 

[Andy Pope]

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

 

[Guest]

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.