title: Chart always complains about invalid references - Excel 2007
body: <p>I made a XY plot that shows points from one data set in two different colors, depending on a set of conditions. I achieved this by making the source table three columns instead of two. First column is the X. Second column is Y is one set of conditions apply, third column is Y is the other set of conditions apply. So the second and third columns have formulas like this in them, respectively:</p>
  
  <pre><code>=IF(ConditionApplies,YValue,"")
  =IF(ConditionApplies,"",YValue)
  </code></pre>
  
  <p>(So the graph actually has two series, each of which is not a contiguous block of numbers - each is interspersed with "nothing")</p>
  
  <p>When I make a change that affects the ConditionApplies, the table reacts properly. Then I switch to the chart (on a different sheet) and it always says: "A formula in this worksheet contains one or more invalid references...". Click OK.</p>
  
  <p>The chart itself always looks the way I would expect, with two different sets of points according to the Conditions I devised. If I inspect the data source fields, all the references are intact and proper.</p>
  
  <p>Basically everything works, I would just like to avoid this annoying pop-up.</p>