Thread: how do I stop excell graphing no data as a 'zero' result?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default how do I stop excell graphing no data as a 'zero' result?
Where there are zeros (or blanks) insert =NA()
This will display as #N/A and will be ignored by the chart engine
Not pretty on your report? Use conditional formatting to hide the N/a
Formula is =ISNA(A1)... format to make cell font colour match cell
background colour
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Patti" wrote in message
...
my line keeps bouncing back to zero instead of showing a gap

Reply With QuoteReply With Quote