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

Hi Thorsten,

Thorsten Kampe schrieb:
> 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)?

First create a chart from only one sheet. Set the chart in edit mode and 
then from the context or Format menu use item 'Date Ranges'. Goto tab 
'Data Series' and add the data series of the other sheets one by one. 
Because your series start not in the same cell address, you cannot use 
the simplified data range on tab 'Data Range'.
Select the ranges including empty cells, as large as they might become. 
In the data series property you can determine how empty cells are handled.

> 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?

For really 'automatically' you will need a macro.

kind regards
Regina

--
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