Re: [libreoffice-users] [Calc] Create and export chart

Hi

        I sent an e-mail answer to Mr. Kampe with How to I think he would solve
his problems.

        I sent directly because I think this users@ list not accept add files
and I sent three files to him with the answer, because is to hard to
explain all with words.

        If someone wants to know the answer with "How to", send an e-mail to
this users@ list and I will send a copy.

Regards,

Jorge Rodríguez
_______________



El mié, 13-07-2011 a las 19:13 +0200, Thorsten Kampe escribió:
> Hi,
>
> I have a Calc file which contains multiple sheets.
>
> - every sheet contains one month of data: from May 2010 to July 2011.
>
> - every sheet has two columes: in column A the days and in column B the 
> actual data.
>
> For example:
>
> [July 2011 Sheet]
>   A      B
> 1 07/02  75.6
> 2 07/03
> 3
> 4 07/04  76.4
> 5 07/05  76.3
> 6 07/06  76.2
> 7 07/07
> 8 07/08  75.6
>
> The data entries are sometimes empty (07/07 for example), do not always 
> start on the 1st and there are some empty rows in between.
>
> Problem 1: I want to create a chart of all sheets/months. What do I have 
> to enter for Date Range in step 2 of the chart wizard (pre-selected is 
> $'July 2011'.$A$1:$B$3)?
>
> Problem 2: I'd like to automatically create this chart every day and 
> export it to a PNG file. Is that doable via LibreOffice Calc?
>
> Thanks in advance, Thorsten

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted