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

* Regina Henschel (Wed, 13 Jul 2011 22:36:31 +0200)
> Thorsten Kampe schrieb:
> > I'd like to create a line chart with the values from columm A (the
> > dates) as the X axis and the values from column B for the Y axis and
> > this from all sheets in the spreadsheet. As if I would not have used
> > multiple sheets but would have put all the data just in one.
>
> OK, that is clearer now. You have to use the tab "Data Series". For
> the role "X-Values" you would write $Sheet1.A2:$Sheet3.A6 and for the
> role "Y-Values" you would write §Sheet1.B2:$Sheet3.B6, for example.
> The chart is drawn as if the data are $Sheet1.A2:B6 followed by
> &Sheet2.A2:B6 followed by $Sheet3.A2:B6.

That sounds good but the result doesn't look right. See the chart for 
multiple sheets[1] versus the chart I created by copying the data of all 
sheets into one sheet[2].

Thorsten
[1]
<http://www.screencast.com/users/thorstenkampe/folders/Default/media/98e
43905-12b5-4ff8-9ac7-f0f06e365d5d>
[2] 
<http://www.screencast.com/users/thorstenkampe/folders/Default/media/642
d5074-ba43-46ba-83c9-ee09623dadba>


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