title: Apache POI generate excel chart
body: <p>All:</p>
  
  <p>Pretty new to Apache POI and excel VBA, how can I implement something like this in Java with Apache POI or any other java lib:</p>
  
  <p>VBA code in Excel:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Sheets("Sheet 1").ChartObjects("Line Chart")
  .Chart.Axes(xlValue).MaximumScale = Sheets("Sheet 1").Range("A37")
  </code></pre>
  
  <p>I can not find any Chart related API working like this, any thought?</p>
  
  <p>Another way around is: My goal is to use Java automatically update cell A37 and give its value as "Line Chart"'s xAxis Max scale, is there a way now to directly call this VBA code thru POI?</p>
  
  <p>Thanks,</p>