hello ...
I have around 60K lines of input with the product name day and time that they were produced and day and time that they were sold. Is it possible to create a view with all these data in a gantt chart format (i gues) ...
input exemple:
producta 2010-01-01 10:00:00 2010-01-02 12:00:00
productb 2010-01-02 11:00:00 2010-01-05 13:00:00
productc 2010-01-03 12:00:00 2010-01-03 02:00:00
productd 2010-01-02 15:00:00 2010-01-04 10:00:00
producte 2010-01-03 12:00:00 2010-01-06 19:00:00
productf 2010-01-04 12:00:00 2010-01-05 17:00:00
output exemple:
01 02 03 04 05 06 07
producta ----->
productb ------------->
productc ------------->
is it possible to do this with Excel 2k3, 2k7 or 2010 ? or is there any software or add on for this ??
Bookmarks