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

Hi Thorsten,

Thorsten Kampe schrieb:
> * Dennis E. Hamilton (Wed, 13 Jul 2011 13:04:23 -0700)
> > 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.
>
> 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.

Kind regards
Regina

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