Re: [libreoffice-users] Single graph line from multiple rows of data

Hi :)
Is each year on a separate tab? or separate columns?

It might be possible to get Base to read the different tabs and collate the data into a single 
table/sheet and then produce the graphs from that.
Regards from
Tom :)



--- On Thu, 15/3/12, Dag Wieers <dag@wieers.com> wrote:

From: Dag Wieers <dag@wieers.com>
Subject: [libreoffice-users] Single graph line from multiple rows of data
To: users@global.libreoffice.org
Date: Thursday, 15 March, 2012, 10:45

Hi,

I was just wondering if this is possible. I have a spreadsheet document that consists of the 
following structure

      Jan  Feb  Mar  Apr  May Jun  Jul  Aug  Sep  Oct  Nov  Dec
2010 2011
2012

Is it possible to have a graph spanning multiple months/years on the X axis showing a single line 
on my graph ?

 ^
 |                 _.
 |      _.      _.'
 |   _.'  '.__.'
 | .'
 +--------------------------->
   J A J O J A J O J A J O
   2010    2011    2012

The default behaviour is to have multiple lines for each month or for each year in a single graph, 
but I want to span multiple years.

Possible or workarounds ?

Thanks,
-- -- dag wieers, dag@wieers.com, http://dag.wieers.com/
-- dagit linux solutions, info@dagit.net, http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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