poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Iain.Sheph...@barclayscapital.com>
Subject RE: Antwort: Re: HSSF - Changing chart series size.
Date Fri, 07 Jan 2005 13:38:18 GMT
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: Joern.Karthaus@kampf.de [mailto:Joern.Karthaus@kampf.de] 
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 <danny@muibros.com> 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.

Colin.Burroughs@ubs.com 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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/









---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message