* 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
