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