title: charts and shapes does not move when row inserted in excel in c# programmatically
body: <p>When I insert a row in Excel charts and other shapes does not move with their cells.<br>
  Let's say I have a chart at A5:D:10, then i insert a row below 2nd row, so now chart should be at A6:D:11, but the chart stays there and hides the 5th row.     </p>
  
  <p>I design a template containing a chart and a shape, then at runtime I am supplying data to the chart and changing a few properties of the shapes. Now my chart contains some data in its first 5 rows and I insert a row after the 2nd row then everything should go one row down, but this is not happening.     </p>
  
  <p>At design time I have checked if the chart's property to <code>move and size with cells</code> is set to true. Yet this is not happening at runtime programmatically. Although at design time inserting rows have no issues.    </p>
  
  <p>Please help me to solve my problem<br>
  Thanks.</p>