View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Typical Village Idut Typical Village Idut is offline
external usenet poster
 
Posts: 2
Default Charting zeros as non zeros

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?