Dag,

On 03/15/2012 06:45 AM, Dag Wieers wrote:
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,
I would set up a summary sheet with the data. For example the months are listed in column A and staring in B1 list the data for each year then use the Chart wizard. You may need to work with the exact layout of the data to get exact plots you need.

--
Jay Lozier
[email protected]


--
For unsubscribe instructions e-mail to: [email protected]
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

Reply via email to