Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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.