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

Hi :)
This sort of summary report is usually easier in a proper database program such 
as Base.  Coincidentally Base can read Calc/Excel files so you wouldn't have to 
"transfer" any data, just use what you have.

Personally i would probably stick to Calc and insert a new sheet that calculated 
summaries from all the other sheets and then use that as the basis for a chart.  
You could even create those 2 sheets in another file that just referenced the 
original although that tends to get messy as it asks for permission to update 
"links" to the original and complains if it can't find the file.  I'm not sure 
how to create charts in Base.  


The bit i would be really stuck over is exporting that as a png or any other 
image format.  Perhaps Draw might help?  I have never used Draw so i don't know 
what it can do.  The chart in Calc would be constantly updated.  If any new data 
was entered into the other sheets the chart would reflect that.
Regards from
Tom :)





________________________________
From: Thorsten Kampe <thorsten@thorstenkampe.de>
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 18:18:38
Subject: [libreoffice-users] [Calc] Create and export chart

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


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