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