View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_55_] Dave[_55_] is offline
external usenet poster
 
Posts: 6
Default Excel 2007 Chart Plot #N/A Data labels

OK - I'm using the =na() trick to keep missing values from plotting a
zero value. Now, the only issue I can’t resolve is the data labels.
Excel is labeling the missing (empty) points with "#N/A"

This is not the behavior I desire. I'd like Excel to "not label"
those (missing) points associated with =na()

Any ideas??

Thanks