Results 1 to 4 of 4

Thread: Transfer Gantt charts from MS Project to MS Powerpoint

  1. #1
    Join Date
    Feb 2006
    Posts
    99

    Transfer Gantt charts from MS Project to MS Powerpoint

    I have got some projects in Microsoft Project 2003 and I want to transfer the gantt charts to microsoft powerpoint? So does anyone know any ways how to do that. Thanks for any help.

  2. #2
    Join Date
    Nov 2005
    Posts
    403

    Re: Transfer Gantt charts from MS Project to MS Powerpoint

    You can try to copy picture to office wizard button on the analysis toolbar if you want. There is also another way to do this by using the Copy Picture button on the Standard toolbar to create a Gif image file which you can insert into Powerpoint or MS word. Hope this will help you out to solve the issue.

  3. #3
    Join Date
    Feb 2006
    Posts
    99

    Re: Transfer Gantt charts from MS Project to MS Powerpoint

    Thank you but I have used the below VBA Macro, since it avoids the requirement for a wizard and copies a WMF file instead of the bitmap file. All I did was just assign it to a button and then selected the tasks that I wanted to copy. It also finds out the proper start and stop dates on the tasks as selected:

    Code:
    Sub CopyTasks()
    Dim TC As Task
    Dim seltasks As Tasks
    Dim StartDate As Date
    Dim EndDate As Date
    EndDate = #1/1/1980#
    StartDate = #12/31/2020#
    
    Set seltasks = ActiveSelection.Tasks
    On Error GoTo skipTask:
    For Each TC In seltasks
    If Not TC Is Nothing Then
    If TC.Start < StartDate Then
    StartDate = TC.Start
    End If
    If TC.Finish > EndDate Then
    EndDate = TC.Finish + 20
    End If
    End If
    skipTask:
    Next TC
    ' Adjust back one week
    StartDate = DateAdd("ww", -1, StartDate)
    EditCopyPicture Object:=False, ForPrinter:=0, SelectedRows:=1,
    FromDate:=StartDate, ToDate:=EndDate, ScaleOption:=pjCopyPictureShowOptions
    End Sub

  4. #4
    Join Date
    Nov 2005
    Posts
    709

    Re: Transfer Gantt charts from MS Project to MS Powerpoint

    That great, thanks for letting us know the script.

Similar Threads

  1. MS Project Cost per resource in Gantt View
    By Projectproject in forum Windows Software
    Replies: 1
    Last Post: 20-04-2011, 06:27 PM
  2. ms project --Gantt chart based on Actual %
    By sitharaiqbal in forum Windows Software
    Replies: 10
    Last Post: 17-02-2010, 06: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, 04:13 PM
  4. Bubble Charts in PowerPoint 2007
    By Nickason in forum MS Office Support
    Replies: 2
    Last Post: 08-05-2008, 04:46 AM
  5. Replies: 1
    Last Post: 05-04-2005, 08:11 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,717,387,338.24902 seconds with 16 queries