If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a gantt chart automatically
I have a table that gets imported to Excel that has
project numbers, begin and end dates. I want to be able to create a gantt chart for this automatically on another sheet when this data gets imported to the first. It would also be nice to be able to have one sheet be by days, another by weeks, and another by months. Can anyone tell me if there is an existing wizard to do this. Maybe point me in the right direction to find information on this? Thanks, Sue |
#2
|
|||
|
|||
creating a gantt chart automatically
Sue -
The best I can do is point you to a list of Gantt chart links I've amassed: http://peltiertech.com/Excel/GanttLinks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Sue W wrote: I have a table that gets imported to Excel that has project numbers, begin and end dates. I want to be able to create a gantt chart for this automatically on another sheet when this data gets imported to the first. It would also be nice to be able to have one sheet be by days, another by weeks, and another by months. Can anyone tell me if there is an existing wizard to do this. Maybe point me in the right direction to find information on this? Thanks, Sue |
#3
|
|||
|
|||
creating a gantt chart automatically
Jon - I get an error on that - Invalid link. I went to
http://PeltierTech.com/Excel/ (which by the way is really cool) and then clicked on the Gantt Charts from there and got the same thing. Sue -----Original Message----- Sue - The best I can do is point you to a list of Gantt chart links I've amassed: http://peltiertech.com/Excel/GanttLinks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Sue W wrote: I have a table that gets imported to Excel that has project numbers, begin and end dates. I want to be able to create a gantt chart for this automatically on another sheet when this data gets imported to the first. It would also be nice to be able to have one sheet be by days, another by weeks, and another by months. Can anyone tell me if there is an existing wizard to do this. Maybe point me in the right direction to find information on this? Thanks, Sue . |
#4
|
|||
|
|||
creating a gantt chart automatically
This link should work:
http://www.peltiertech.com/Excel/Charts/GanttLinks.html Susan W wrote: Jon - I get an error on that - Invalid link. I went to http://PeltierTech.com/Excel/ (which by the way is really cool) and then clicked on the Gantt Charts from there and got the same thing. Sue -----Original Message----- Sue - The best I can do is point you to a list of Gantt chart links I've amassed: http://peltiertech.com/Excel/GanttLinks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Sue W wrote: I have a table that gets imported to Excel that has project numbers, begin and end dates. I want to be able to create a gantt chart for this automatically on another sheet when this data gets imported to the first. It would also be nice to be able to have one sheet be by days, another by weeks, and another by months. Can anyone tell me if there is an existing wizard to do this. Maybe point me in the right direction to find information on this? Thanks, Sue . -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|