« Going Square | Main | Microsoft Project 2007 VBA Help now Available Online »

Project Scheduling with Excel

For the "I Hate Microsoft Project" crowd some new hope glittered today with a couple of posts on making Project schedules and charts in Excel. The secret is using an xy chart with error bars (my version uses formulas and conditional formatting and can do resource profiling but doesn't look nearly as clean. The post and example files are at Process Trends

Then Dick Kusleika chimed in and added progress lines. His example is here Daily Dose of Excel. A couple other approaches are referenced in his comments as well.

Excel is immensely useful... but it isn't a substitute for a real scheduling tool. Sorry Project haters.

  • VBA returns in Excel 2011 for Mac
  • Trouble with Assignment Units in Project 2010?
  • Seeing Other Scheduling Software
  • Office VBA for Mac After 2008
  • Analyze Microsoft Project Resource Usage Data In Excel
  • Microsoft Project VBA - the Instr function
  • OpenProj First Look
  • All your models are belong to us
  • VBA Writing to a text file (MS Project, Excel)
  • MS Project VBA - Trim Function

  • Comments (1)

    Julien Deflassieux:

    Dear Sir or Madam,
    I am trying to have as a finish date the actual date of the day so that each time I open msproject, I have the gantt chart bar increasing automatically (the finish date will be entered manually and the bar stopped at the desired date). It should greatly improve the global vision of delays occuring in tasks. I have tried the following without success :
    right click finish column, customize field, then type finish #1, formula (now())) and finally use formula. I have tried this with both finish column and duration column without any success. I would be so very greatful if you could provide a solution for this matter and apologize if this "comments" section has another purpose than to post questions.
    Thanks in advance,


    Post a comment

    (Comments are moderated to fight SPAM and will be published after I have a chance to approve them. Thanks for waiting.)


    The previous article is Going Square.

    The next article is Microsoft Project 2007 VBA Help now Available Online.

    Current articles are in the main index page and you can find a complete list of articles in the archives.

    Creative Commons License
    This weblog is licensed under a Creative Commons License.
    Powered by
    Movable Type 3.34