开发者

Durations of tasks -- how to generate gantt-like chart from CSV

I have this CSV data:

Task,From,To,Duration
Task 1, 2011-02-20 12:30.12, 2011-02-20 12:32.33, 3422
Task 2, 2011-02-17 15:39.32, 2011-02-18 9:05.23, 345
Task 3, 2011-02-15 09:02.09, 2011-02-18 9:05.24, 3453455

And I would like to generate something like a gantt chart showing when task has started and ended with seconds granularity.

Is there any tool of Excel template which can do this job easily?

I do开发者_如何转开发nt want to set up gantt charts in excel every time I paste data. Just to load CSV into some app. and see. :)

Thank you Martin


I finally found one good solution:

I am using graphical tool GNUPlot (http://www.gnuplot.info/). Graph is generated thanx to this great python script:

http://wiki.mn.wtb.tue.nl/wonham/gantt.py


I wrote this CSV to Gnome Planner converter script in Python

Here it is in action:

Durations of tasks -- how to generate gantt-like chart from CSV


An Windows App called WinCalendar converts CSV or Excel data to Gantt Charts in Excel. See: wincalendar.com/Gantt-Chart

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜