+ Reply to Thread
Results 1 to 2 of 2

Planned vs. Actual Gantt

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,059

    Question Planned vs. Actual Gantt

    Hi,

    Has anyone one ever made a good template that would lists out tasks, planned start, finish vs. actual start & finish dates on one line & still have it produce a 2 bar Gantt chart?

    I managed to get a 2-bar Gantt chart, but I don't like the template to create it, which requires my dates or durations to be on 2 lines. This format messes up my Task Template.

    If would be greatly appreciated if someone has a template that could do this or can structure a formula to distinguish my planned start/finish vs. actual start/finish & still be able to generate a 2-bar Gantt chart.

    Thanks
    MyCon
    -- Using Latest Version of Excel

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Planned vs. Actual Gantt

    Hello,

    hard to give advice without seeing what you've already got in place.

    Chandoo has quite a few templates for project management. Here is a link to his approach to Gantt charts: http://chandoo.org/wp/2009/06/16/gan...ct-management/

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1