Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


On 03/15/2012 06:45 AM, Dag Wieers wrote:

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

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 ?

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

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.