Results 1 to 7 of 7

Thread: export gantt chart from Project 2007 to Excel

  1. #1
    Join Date
    Aug 2006
    Posts
    332

    export gantt chart from Project 2007 to Excel

    Can anyone tell me how to export a Gantt Chart from Project 2007 to either Excel 2007 or MS Word? Thanks for any help.

  2. #2
    Join Date
    Nov 2005
    Posts
    709
    You can try to edit, copy picture to take a gif file that you can insert anywhere you want. I am actually not a computer expert since I dont know any other way to insert pdf files into Excel or Word.

  3. #3
    Join Date
    Oct 2005
    Posts
    725

    Re: export gantt chart from Project 2007 to Excel

    Did you find the gif file to be not that good at showing the whole chart? I have reverted to printing the schedule to a PDF file and then I will insert that into the document.

  4. #4
    Join Date
    Sep 2005
    Posts
    1,306

    Re: export gantt chart from Project 2007 to Excel

    If you want to insert a pdf file into an Office 2007 software then you can try to select the insert menu and then Object and finally select Adobe Acrobat document.

  5. #5
    Join Date
    Nov 2009
    Posts
    2

    Re: export gantt chart from Project 2007 to Excel

    Can anybody tell me a way to limit the timescale? When the conversation to a PDF is done it puts the time scale up for the whole project (59 wks). The tasks I am trying to show is for 29 week.

  6. #6
    Join Date
    Jan 2006
    Posts
    3,798

    Re: export gantt chart from Project 2007 to Excel

    If you are trying to print to pdf then the print menu has a timescale setting that you can use as well.

  7. #7
    Join Date
    Nov 2009
    Posts
    2

    Re: export gantt chart from Project 2007 to Excel

    Prefect. That worked.

    One other question. I prefer to have the dates show as work weeks. The problem is for 2009 the calendar is showing 53 weeks but my company only has 52 weeks. Is there any way to adjust the standard calendar to stop at 52 for 2009?

    Thanks.

Similar Threads

  1. Print out of GANTT Chart Project 2010
    By KOVID in forum Microsoft Project
    Replies: 1
    Last Post: 26-03-2010, 03:43 PM
  2. ms project --Gantt chart based on Actual %
    By sitharaiqbal in forum Windows Software
    Replies: 10
    Last Post: 17-02-2010, 05:27 PM
  3. Add a Text Note to a Gantt chart in project
    By rasena in forum Microsoft Project
    Replies: 4
    Last Post: 25-01-2010, 03:13 PM
  4. Export MS Project 2007 to Excel
    By Manik in forum Microsoft Project
    Replies: 4
    Last Post: 13-02-2009, 09:34 PM
  5. Replies: 1
    Last Post: 05-04-2005, 08:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •