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

Hi :)
You probably can do it all in one sheet but 2 would probably be easier to 
trouble-shoot later if you ran into problems.  

What type of chart are you hoping to end-up with?  Do you want a single line 
representing the entire year or do you want to compare months against each 
other?  


For the latter option my way would be fairly clumsy.  On the calculations sheet 
the A column would give the dates from Jan & B the data from Jan.  C & D would 
be Feb.  E & F would be March.  I would set-up the first row and then drag the 
equations down as far as required. In A an equation such as 

=Sheet1.A1

unless you have renamed Sheets to the name of the month in which case something 
like
=Jan.A1
drag this to copy into B.  C would need a new equation
=Sheet2.A1
Now if you select those 3 cells you can probably drag-fill all the remaining 
columns, then drag-fill down.  


Hmm, you probably want a graph showing the whole year in a line?  I would be 
fairly clumsy with that too tbh.  Someone is likely to have a much better answer 
in a few hours but it would help to know what you are aiming for.  

Regards from
Tom :)





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

* 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


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