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

Hi Dag,

Dag Wieers schrieb:
> 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 ?

It should be possible, but it is actual broken for category charts like 
"line". Fix will not be in 3.5, but in 3.6.
https://bugs.freedesktop.org/show_bug.cgi?id=44832

You can use an XY-chart with subtype 'line' as workaround.

You need to enter the ranges manually in the second tab of the data 
ranges dialog. The delimiter between to ranges is a semicolon.

Kind regards
Regina




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