Hi :) As i see it the problems are 1. to get the full years data onto one sheet 2. remove any rows where there is no data for a particular day Making the chart based on that would be very easy 4. exporting as png dynamically
I'm beginning to think my initial suggestion of using Base might not have been as bad as i first thought. A simple Query table would add all the values and dates from the various sheets. I would use another Query to remove the blanks but that could be done in the same Query. I've not used Base to create charts but i suspect it would be easier to use that chart wherever it's needed. Is the png needed for displaying on a web-page? Regards from Tom :) ________________________________ From: Michael D. Setzer II <[email protected]> To: [email protected] Sent: Wed, 13 July, 2011 21:08:57 Subject: Re: [libreoffice-users] Re: [Calc] Create and export chart On 13 Jul 2011 at 20:09, Thorsten Kampe wrote: To: [email protected] From: Thorsten Kampe <[email protected]> Subject: [libreoffice-users] Re: [Calc] Create and export chart Date sent: Wed, 13 Jul 2011 20:09:50 +0200 Send reply to: [email protected] > * Tom Davies (Wed, 13 Jul 2011 18:42:47 +0100 (BST)) > > 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. > > So you cannot create charts in one sheet that takes data from another > sheet from within the same Calc file? There is no $'ALL SHEETS'.$A$1:$B > $3)?? > > If not how can I create a sheet that includes all the other sheets' > values? > > Thorsten I was playing with this, and couldn't figure a way to get data from different sheets into a chart, but did come up with something interest. In a single sheet, I put the dates in column A from 1/1/2011 thru 12/31/2011. Used =randbetween(1,10) in column B just to have some data. Then did an XY graph using the Block, and that showed the whole years of data. Then went into the X-axis Scale, and turned off automatic, and set the minimum to 3/1/2011 and maximum to 3/30/2011 as a test, and got a chart with that data range.. Haven't done much with Calc, so there might be a way to automate the process? > > > -- > Unsubscribe instructions: E-mail to [email protected] > In case of problems unsubscribing, write to [email protected] > 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 > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10996793.814598 | EINSTEIN 6176402.050851 ROSETTA 3370540.763838 | ABC 6867671.595982 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
