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

I have some line graph charts where the the first data point in drawing a line from zero. Thi coul imply the first value is zero but its not.

Example data would be A1 = , A2 = , A3 = 5, A4 = 6, A5 =

The line graph in my mind should plot the values 5,6 and 7 however it is assuming A2 = 0 and is drawing this line. To shed a little more light on this the data source is derived from a custom function where I have told it to return "" if in error. Is this the problem? Is there a way to return nothing from a function so the cell is really empty

Another consideration is that the solution cannot ingore zeros as there are cases these need to be plotted. Essentually I believe I nee to know how to deal with a non-result...

Brian