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

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