Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.