Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Project Training and help » Gantt charts

Gantt charts

ResolvedVersion 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:

Format individual bars on your GANTT chart

To draw attention to a bar on your Gantt chart simply double click it. From the dialogue box that opens make your selection of text and bar modifications.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Gantt charts

Gantt charts

RE: Gantt charts

MS Project articles

MS Project tip:

Format individual bars on your GANTT chart