Gantt charts

Resolved · Urgent Priority · Version 2003

Tue 30 Dec 2008, 13:42 Delegate Richard said...

Richard has attended:
No courses

Gantt charts

Does anybody know how to copy a whole Gantt chart, (Tasks and timelines) into a spreadsheet?

Thanks, Richard

Mon 5 Jan 2009, 10:26 Trainer Stephen said...

RE: Gantt charts

Hi Richard

Thank you for your question

It is possible to copy the tasks into excel using the Save as Excel Spreadsheet option.
This however will not copy across the task bars as Excel has no way to visualise them. It might be possible to write a macro in Excel to create the task bars, but this would be a substantial undertaking

Regards

Stephen

MS Project tip:

Email a Task

When you need to communicate important information to your project staff use Microsoft Project 2003 to send them a note using outlook or an e-mail system.

1.In a task sheet, select the task or tasks which you want to send a project note.

2.On the File menu, point to Send To, and then select Mail Recipient (as Schedule Note).

3.Under Address message to, select the recipients of your note.

View all MS Project hints and tips

Gantt charts

Gantt charts

RE: Gantt charts

MS Project articles

MS Project tip:

Email a Task