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:
An Windows App called WinCalendar converts CSV or Excel data to Gantt Charts in Excel. See: wincalendar.com/Gantt-Chart
精彩评论