Lilliabeth
Technical User
Is it possible to create Project Gantt charts programmatically?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create Gantt Charts Programmatically
- Thread starter Lilliabeth
- Start date
- Status
Microsoft did 
(almost) Anything is possible really... just a matter of cost.
If you just like to show bars representing time for a number of tasks then that can be done fairly easy with some programming knowledge.
I did something similiar in excel with data I produce in access.
You'd basically need data that has
Task
Start Date
Finish Date
Then you could programatically fill the cells for each column in a given row where The heading time values fall between the start and finish date.
(almost) Anything is possible really... just a matter of cost.
If you just like to show bars representing time for a number of tasks then that can be done fairly easy with some programming knowledge.
I did something similiar in excel with data I produce in access.
You'd basically need data that has
Task
Start Date
Finish Date
Then you could programatically fill the cells for each column in a given row where The heading time values fall between the start and finish date.
Your question makes little sense.
If you mean how do you create a Gantt chart and have the data developed from the Gantt chart to populate the rows and columns in the "spreadsheet" ... well, that makes about as much sense as asking Excel to start with a Graph and develop the underlying information.
If you mean ... how do you enter data and cause Project to automatically create a Gantt chart then tell us where the data are coming from.
If you mean how do you create a Gantt chart and have the data developed from the Gantt chart to populate the rows and columns in the "spreadsheet" ... well, that makes about as much sense as asking Excel to start with a Graph and develop the underlying information.
If you mean ... how do you enter data and cause Project to automatically create a Gantt chart then tell us where the data are coming from.
- Thread starter
- #5
Lilliabeth
Technical User
If you mean ... how do you enter data and cause Project to automatically create a Gantt chart then tell us where the data are coming from.
A SQL Server db.
A SQL Server db.
- Status
Similar threads
- Locked
- Question