Re: [libreoffice-users] [Calc] Create and export chart
Hi :) Nicely done :) The mailing list doesn't accept attachments so off-list is a good work-around. If you send to the list but Cc the person then the person gets the attachments and the list doesn't. Hopefully you will get the 'hilarious joke' i sent as an attachment. I don't know if it's better to send 2 emails or just 1 that goes to the 2 places. The problem with just 1 is that other people are a bit mystified since they can't see the attachment. Regards from Tom :) From: jorge jrodrigue...@cpcecr.com To: users@global.libreoffice.org Sent: Thu, 14 July, 2011 1:50:36 Subject: 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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
Re: [libreoffice-users] [Calc] Create and export chart
Hi Thorsten, On 13/07/11 19:18, Thorsten Kampe wrote: 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. This sounds very much like the rainfall spreadsheet I use currently. Currently it has 19 sheets and it covers the entire year as well as 5 years history. I have attached it for you to view and adapt to your need. I hope it assists you Regards Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
[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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
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 thors...@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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
[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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
Re: [libreoffice-users] [Calc] Create and export chart
On 14/07/11 03:13, Thorsten Kampe wrote: 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 Thorsten, This is how I would address this problem Sheet 1 would include all data (column A B) for every month. Sheet 2 will be the monthly summary sheet. In this sheet we create a stylised month. Cell A1 and B1 would be a picklist of months or years. Use data validity Criteria to set up a list or point to a allowable range. In row A3:AE3 create the numbers 1-31 which represents the day of the month. Then underneath each day in A4:AE4, use the Vlookup() function to extract the data for each day of the month and year selected. The function would look like this... =VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0) to get rid of the annoying situation where absent values throw and error use the following to capture them =IF(ISERROR(VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0)), , VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0)) This will create an idealised month with values populated based on what month and year you select. Create your chart based on this. In regards to exporting as a PNG, several options exist if you are using Windows... 1. use a PDF printer driver that exports to PNG, rather than the inbuild export utility like PDFCreator http://sourceforge.net/projects/pdfcreator/ 2. Use an ImageCreating printer driver like ImagePrinter http://sourceforge.net/projects/imageprinter/ Doing the same in GNU/Linux requires you to install a better PDF Printer Driver than allows you to save as an image or post-process the PDF using another program. Once you set this up to work manually create a macro and attach it to a button or something. -- Cheers Simon Simon Cropper Website Administrator http://www.fossworkflowguides.com The fossWorkflow Guides (c) Simon Cropper CC-BY-SA 3.0 Australia http://creativecommons.org/licenses/by-sa/3.0/au/deed.en -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
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+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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
