Charting zeros as non zeros
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?
|