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