title: How to avoid error warning in dynamic chart if we use zero values and #N/A?
body: <p>I have a problem in running my dynamic chart. I use zero values and #N/A in my chart because it is important to be able to illustrate my data. Zero values indicate the dry period and I use #N/A in order to make gaps in my chart, because if I use zero, it will draw chart in zero values.</p>
  
  <p>I made formula for my dynamic chart by using OFFSET Formula and then use it to my dynamic chart.
  My formula is like :
  WaterLevelSeries: =OFFSET(Datafeeds1!$L$18,0,0,COUNTA(Datafeeds!$L:$L)-1)</p>
  
  <p>and then I change the series data in the graph so that it use this "WaterLevelSeries" formula.</p>
  
  <p>My data is about dry period and the peak flow, so to distinguish between those two, it is important to define zero values for the chart. However there is a warning I received like this :
  <a href="https://i.stack.imgur.com/9bDw2.png" rel="nofollow noreferrer">warning error</a> </p>
  
  <p>and when I tracked it with "F5 then Go to Special" and ticked "Formula", it seems that my excel sheet did not like zero values and #N/A because it highlights my cells that contain those values. 
  However since I really need zero values and this #N/A in my dynamic chart, is there a way to inactivate the error warning? I  tried the option menu in excel (Options - Formulas - unchecked all the Error Formulas Rule), but it did not work. The warning still appeared.</p>
  
  <p>Thank you for your help.</p>