title: Chart won't update in Excel (2007)
body: <p>I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values</p>
  
  <p>The calculated values never change directly, but only as a result of other cells in the sheet changing</p>
  
  <p>When I change other cells in the sheet, the Data Series cells are recalculated, and show new values - but the Chart based on this Data Series refuses to update automatically</p>
  
  <p>I can get the Chart to update by saving/closing, or toggling one of the settings (such as reversing x/y axis and then putting it back), or by re-selecting the Data Series</p>
  
  <p>Every solution I have found online doesn't work</p>
  
  <ul>
  <li>Yes I have Calculation set to
  automatic</li>
  <li>Ctrl+Alt+F9 updates everything fine, EXCEPT the chart</li>
  <li>I have recreated the chart several times, and on different computers</li>
  <li><p>I have tried VBA scripts like:</p>
  
  <p><code>Application.Calculate</code><br>
  <code>Application.CalculateFull</code><br>
  <code>Application.CalculateFullRebuild</code><br>
  <code>ActiveWorkbook.RefreshAll</code><br>
  <code>DoEvents</code>  </p></li>
  </ul>
  
  <p>None of these update or refresh the chart</p>
  
  <p>I do notice that if I type over my Data Series, actual numbers instead of calculations, it will update the chart - it's as if Excel doesn't want to recognize changes in the calculations</p>
  
  <p>Has anyone experienced this before or know what I might do to fix the problem?
  Thank you</p>