View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
LeninVMS[_3_] LeninVMS[_3_] is offline
external usenet poster
 
Posts: 1
Default Don't plot non-values on a chart

Try returning the worksheet function

na()

This will prevent non-values from being assumed as zeros.

If you return "", the chart will most certainly assume it as a zero.

- Leni

--
Message posted from http://www.ExcelForum.com