title: Dynamically change charts in excel
body: <p>I have the following problem. I have a relative large number of excel charts, and I want to be able to change the size of the charts (i.e. width and height) automatically. By automatically I mean the following: I have two cells, one for height and one for width, and when I change them, the charts change automatically, without having to push any other button or anything. For example, cell A1 has the value 100 for width and cell B1 has the value 200 for the height. So, when I change A1 to 200 and B1 to 300 I get all my charts to get bigger. </p>
  
  <p>what I have done up to now is to be able to loop over all charts, and change the shapes, but I need to hit a button first for my macro to run. I would like to find out if there is a way to change the shape of the charts without having to push any button, just by changing the values of the two cells that have the width and the height of the charts. Thanks in advance.</p>