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+h...@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