title: VBA: Modify chart data range
body: <p>My "Chart data range" is <code>='sheet1'!$A$1:$Z$10</code>. I'd like to make a VBA macro (or if anybody knows a formula I can use, but I couldn't figure one out) to increase the ending column of the range for <code>chart1</code> by 1 every time I run the macro. So essentially:</p>
  
  <p><code>chart1.endCol = chart1.endCol + 1</code></p>
  
  <p>What is the syntax for this using <code>ActiveChart</code> or is there a better way?</p>