title: Apache POI modify chart without using named ranges
body: <p>I need to present data from my db into an .xls spreadsheet.
  I can read/write to the xls file without any issue, but obviously I cannot create the chart from scratch.</p>
  
  <p>I read every documentation I could find and created a template file with the chart in Excel to be modified by POI.</p>
  
  <p>The problem I'm facing is the following: I was able to create named ranges, assign them to my chart and modify them through POI, no problem at all. When I reverted to OpenOffice Calc problems started: it has no support for named ranges as data sources for charts, so:</p>
  
  <p>is there any way to update charts data WITHOUT using named ranges (I can give the chart the range myself, every serie is a delimited part of a row)?</p>
  
  <p>Thank you</p>