I had this problem last night, and just found a different solution: You can define the chart data as a reference to a named range. POI can't edit charts, but it can edit named ranges. I think.
Going further, you can avoid editing the named range, if you define a named range for each column like this: ColA = '=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1)' such a named range expands as you add more data to column A. More details: http://office.microsoft.com/en-us/assistance/HA011098011033.aspx Iain Shepherd -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 05:01 To: POI Users List Subject: Antwort: Re: HSSF - Changing chart series size. You can fill the data in a Worksheet and change the series size by a startup Makro. I do so in a Project and it works fine. JK Danny Mui <[EMAIL PROTECTED]> am 06.01.2005 19:20:42 Bitte antworten an "POI Users List" <poi-user@jakarta.apache.org> An: POI Users List <poi-user@jakarta.apache.org> Kopie: Thema: Re: HSSF - Changing chart series size. there is currently no charting manipulation in HSSF. All we do is load and save the binary data at the moment. [EMAIL PROTECTED] wrote: > Hi, > > Is it possible to change the series size of a chart, from say A1..C3 > to A1..F3? If so, how? > > Cheers, > > Colin > > Visit our website at http://www.ubs.com > > This message contains confidential information and is intended only > for the individual named. If you are not the named addressee you > should not disseminate, distribute or copy this e-mail. Please notify > the sender immediately by e-mail if you have received this e-mail by > mistake and delete this e-mail from your system. > > E-mail transmission cannot be guaranteed to be secure or error-free as > information could be intercepted, corrupted, lost, destroyed, arrive > late or incomplete, or contain viruses. The sender therefore does not > accept liability for any errors or omissions in the contents of this > message which arise as a result of e-mail transmission. If > verification is required please request a hard-copy version. This > message is provided for informational purposes and should not be > construed as a solicitation or offer to buy or sell any securities or > related financial instruments. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ ------------------------------------------------------------------------ For more information about Barclays Capital, please visit our web site at http://www.barcap.com. Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Although the Barclays Group operates anti-virus programmes, it does not accept responsibility for any damage whatsoever that is caused by viruses being passed. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group. Replies to this email may be monitored by the Barclays Group for operational or business reasons. ------------------------------------------------------------------------ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
