Discussion:
[libreoffice-users] date line for Calc Gantt charts
dave boland
2015-01-14 21:42:42 UTC
Permalink
All,

I use Calc to do a quick Gantt chart (it is easy if the data is simple).
The problem I'm having is the dates on the X-Axis. What I want is
this:
| | | | | | | ...|
01/15 01/15 03/15 04/15 05/15 06/15 07/15 12/15

What I get is something like this:
| | | | | |
01//01/15 01/30/15 02/04/15 03/02/15 03/30/15 04/02/15

Seems the dates reflect the start dates and duration of the data. I
played with all of the controls, but could not find a way to do what I
want. Any suggestions (besides a Gantt Chart program)?

Dave,
--
dave boland
***@fastmail.fm
--
http://www.fastmail.com - Accessible with your email software
or over the web
--
To unsubscribe e-mail to: users+***@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
Tom Davies
2015-01-15 15:48:59 UTC
Permalink
Hi :)
Err, i am not sure if this template might help;
http://templates.libreoffice.org/template-center/gantt-chart-template

This YouTube video might help, maybe.

I couldn't watch it on the locked-down system i'm using again today

Also found these links, which i am not sure if they help or not;
http://seabright.co.nz/2011/05/25/basic-gantt-charts-using-libreoffice-calc-charts/
which i got from
http://opensourceecology.org/wiki/Gantt_Chart_Template_for_OpenOffice_Calc

and from OpenOffice
http://templates.openoffice.org/en/template/gantt-chart-template
but i think that might have been updated and posted in the first link i gave.

Regards from
Tom :)
Post by dave boland
All,
I use Calc to do a quick Gantt chart (it is easy if the data is simple).
The problem I'm having is the dates on the X-Axis. What I want is
| | | | | | | ...|
01/15 01/15 03/15 04/15 05/15 06/15 07/15 12/15
| | | | | |
01//01/15 01/30/15 02/04/15 03/02/15 03/30/15 04/02/15
Seems the dates reflect the start dates and duration of the data. I
played with all of the controls, but could not find a way to do what I
want. Any suggestions (besides a Gantt Chart program)?
Dave,
--
dave boland
--
http://www.fastmail.com - Accessible with your email software
or over the web
--
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
--
To unsubscribe e-mail to: users+***@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 del
Loading...