Ask Your Question
0

Creating a comparative timeline chart in Calc? [closed]

asked 2013-02-06 17:32:18 +0200

SoWhy gravatar image

updated 2014-01-08 01:22:50 +0200

oweng gravatar image

Hi there,

I have a list of dates (start and end dates) with corresponding labels. I want to create a timeline chart such as this one with dates as the x-axis and bars for each label to be shown at the corresponding period of time. Is this possible and if so, how?

TIA
SoWhy

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 13:34:07.325712

Comments

That type of chart is called a Gantt Diagram. See http://en.wikipedia.org/wiki/Gantt_chart for more info.

Mano Engel gravatar imageMano Engel ( 2013-02-07 14:48:39 +0200 )edit

4 Answers

Sort by » oldest newest most voted
2

answered 2013-02-08 19:26:33 +0200

horst gravatar image

You can not make Timeline/Gantt charts with LO. Try this free Gantt program. It might do the trick otherwise you might settle for a program like MS Project.

Gnumeric has a chart type called "Min-Max" which is under construction, no help, no real description. If you want to experiment it might be for you.

edit flag offensive delete link more

Comments

Note that ODF (v1.2, 19.15) does specify details for a chart:class attribute of chart:gantt and gives details (p.331 and p.336) of how a Gantt chart is to be implemented. Currently this part of ODF does not appear to be implemented by LO. ODF v1.0 and v1.1 also specified the same chart type.

oweng gravatar imageoweng ( 2014-03-19 12:52:27 +0200 )edit
1

answered 2013-02-27 07:27:03 +0200

ROSt52 gravatar image

IMHO Gantt charts in Calc or more often in Excel are a nightmare in terms of wasting time and still not having what is needed. I have seen so many people wasting a lot of time. Creating a Gantt chart in Calc or Excel was never an option for me.

In my strife to get rid of MS as much as possible, I looked around to open source SW replacing MS Project but did not find a really good one yet.

The best I found is LibreProject which was called before OpenProject. Accidentially or purposely???

The GanttProject mentioned by @horst, was new to me. (Thanks horst!) A first very quick glance on the demo video gave the impression that it is worthwhile to install and test the program.

My comparison standard is always MS Project because I used this program intensively. It is good. Maybe the best MS created. But there are also a lot of features in, which I never used. However, handling of the Gantt Charts, scheduling, rescheduling, splitting of tasks, linking various projects, and the import and export to Excel are great.

As for an enhancement request concerning Calc, I would not forward it. It will overload Calc and starting with a new Office component for scheduling will overload our devs.They do a great job with the current 6 components and have to fix quite a number of bugs and work on many enhancement requests.

Maybe LibO can put things together with LibreProject or the GanttProject to ensure a good import and export functionality to and from Calc. This something that I regards as feasible and also desirable.

But coming back to @SoWhy's question, I heavily recommend him to follow the hint from @horst and try GanttProject or the LibreProject I mentioned. I expect that both are far from MS Project but much better than what can be created in Calc.

edit flag offensive delete link more
1

answered 2013-02-06 23:05:03 +0200

m.a.riosv gravatar image

Hi SoWhy, take a look to attached file, maybe a point to began.

GráficosBarrasApiladasHorizontales_ChartBarStackedHorizontal.ods

edit flag offensive delete link more
0

answered 2013-02-27 05:12:32 +0200

qubit gravatar image

Hi @SoWhy,

Per @horst, LO doesn't currently support Gantt charts, however this might be a useful feature to add to LibreOffice. I don't see any bugs filed about this feature in the bug tracker, so please consider filing an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format "fdo#123456".

Thanks!

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-02-06 17:32:18 +0200

Seen: 15,483 times

Last updated: Jan 08 '14