You can see if it is possible to select a cuboid, but that may or may not provide what you want.
Also, there is an interesting problem of maintaining the correspondence between the column A
entries and the column B entries if that is important to you.
A cuboid is a range that starts on one sheet (say the upper left or the left-most column) and ends
on the final sheet (say the lower right or the right-most column).
This is a provision of OpenFormula in ODF 1.2 but I don't know what the implementation is in
LibreOffice.
A lot of how this works really depends on what it is you want in the chart - then you can figure
out how to boil the date from the other sheets down to produce the data that is exactly the basis
for the chart.
I don't want to speculate farther because it is not clear what can work without understanding what
you want as the chart data.
- Dennis
-----Original Message-----
From: Thorsten Kampe [mailto:thorsten@thorstenkampe.de]
Sent: Wednesday, July 13, 2011 11:10
To: users@global.libreoffice.org
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.