title: Excel 2013 vba refresh chart content after each iteration of For Loop
body: <p>Problem: Refresh graphical representaion of Series in ChartObject after each iteration of for loop</p>
  
  <pre><code>Ex. y=m*Cos(x) 
  y - Values
  m - parameter
  </code></pre>
  
  <p>I have some data counted from formula with parameter. I want to visualise what influence has the change of parameter on XYgraph. I want to do it in for loop (added <code>Sleep</code> do have some time to see results).
  Data and formula are in Excel SpreadSheet. Update script of parameter is in VBA module. Update works on values in spreadsheet but doesn't affect graph.</p>
  
  <p><code>WorkBook.RefreshAll</code> doesn't work;
  <code>Chart.Refresh</code> doesn't work</p>
  
  <p>Chart updates after last iteration.</p>
  
  <p>Any ideas?</p>