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

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
jslozier@gmail.com


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