title: How to move position of chart in excel by Java POI
body: <p>I want to add row in excel by java POI and I try with both <code>shiftRows()</code> function and <code>createRow()</code> function</p>
  
  <p><a href="https://i.stack.imgur.com/RJYb6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RJYb6.jpg" alt="enter image description here"></a>
  <br>
  both function can add row in excel but below chart position is remain and not move </p>
  
  <p>I also like to move (shift down) the position of chart </p>
  
  <p>I use poi version 3.9</p>
  
  <p>Can anyone give me the advice or idea to move the position of that chart image</p>
  
  <p>As the fact, the data range of chart also not changed. I need not only to move the position of charts but also need to increase the data range of chart </p>
  
  <p>thanks!!</p>
  
  <p><a href="https://i.stack.imgur.com/COTMk.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/COTMk.jpg" alt="enter image description here"></a> </p>