title: How to get chart to ignore text/blank? - EXCEL
body: <p>I have a column in a table that has the following formula </p>
  
  <pre><code>=IF([@[JoBM]]&gt;0; IF([@[JoBF]]&gt;0;[@[Median1]]/[@[Median2]];"-");"-")
  </code></pre>
  
  <p>The column has looks something like this: 0.9, 0.84, - , - , 1.2, 0.93, 1.3, - </p>
  
  <p>From this column I need to create a graph that ignores the "-". The "-" needs to be included in the table for visual purposes. Any ideas?</p>