Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Project
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Export timephased (or timescaled) project data to Excel
 

If you want to display timephased (timephased: Task, resource, or assignment information that is distributed over time. You can review timephased information in any available time period in the fields on the right side of the Task Usage and Resource Usage views.) (or timescaled) information in a Microsoft Office Excel 2003 graph or chart, you can export it using the Analyze Timescaled Data Wizard.

  1. On the View menu, click Gantt Chart.
  2. If applicable, select the tasks you want to export.
  3. On the View menu, point to Toolbars, and then click Analysis.
  4. Click Analyze Timescaled Data in Excel.
  5. Following the Analyze Timescaled Data Wizard instructions, click the fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) you want to export to Excel.

To learn other ways to export data from Project, see the related links in the See Also box, which is visible when you are connected to the Internet.

Notes

  • Timescaled information is also known as timephased information.
  • If you don't see any information exported, then you may not have specified which fields to use in the wizard. Re-run the wizard and select the fields you want to export in step 2 of the wizard.
  • The wizard does not export resource assignment information.
advertisement