Charting zeros as non zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Replace the blanks by NA() which displays as #N/A.
These values are ignored by the Excel chart engine
best wishes
 
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
 
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.
 
Back
Top