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

* Thorsten Kampe (Thu, 14 Jul 2011 03:26:01 +0200)
> * 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].

I finally figured it out. For reasons I don't fully understand yet, it 
was the wrong chart type: Line > Lines Only instead of XY (Scatter) > 
Lines Only. I switched to the latter and it started looking right[1] 
(and the same as if using just one sheet).

From my limited understanding and my previous exposure to charts I 
actually wanted a Lines chart and not a XY (Scatter) with lines only[2].

Anyway, thanks to everyone who helped me in this thread; and especially 
thanks to Regina, the queen of charts!

Thanks, Thorsten
[1] http://www.screencast.com/t/9jQqD8oGxD
[2] http://home.gna.org/pychart/doc/module-line-plot.html


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