Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Gantt charts

Resolved · Urgent Priority · Version 2003

Reply Tue 30 Dec 2008, 13:42Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Mon 5 Jan 2009, 10:26Trainer 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 articles

· Understanding Critical Path In Project
· Say 'ello 'ello 'ello To The Team Planner And Task Inspector
· MS Project Courses: Taking your Business from Good to Exceptional in Just 3 Days
· Using Microsoft Project to Create Resource Pools
· Microsoft Project Training Courses

Please browse our web site to find out more about
2002 microsoft project training and other Microsoft training courses.

Ms project tip:

Set default task type - Project 2010

a. In Project, click on the File tab
b. Select Options from left hand side
c. Click on Schedule to set the scheduling options
d. Set the Default Task type box to your chosen option
i. Generally if you plan/estimate your projects using durations you should use fixed duration, and untick the box New tasks are effort driven, if you plan/estimate with person hours use fixed work, or for plans estimated with the proportion of resources time use fixed units, and untick the box New tasks are effort driven)
e. Click OK to apply your changes

View all MS Project hints and tips