Weekly Version of Gantt-style Excel Graph Paper

Weekly Version of Gantt-style Excel Graph Paper

My Gantt Weekly Chart V3 A couple of requests came in for a weekly version of the Gantt Excel spreadsheet. As it happens, I’d solved a similar problem a couple months ago when making the spreadsheets for my Groundhog Day Resolutions review day 3. So I dropped in the logic from those spreadsheets into the Gantt Excel spreadsheet, et voila! It is done!

Like my other Excel Gantt chart, it automatically calculates the dates and formats everything according automatically for you. You just fill in the grid yourself manually, pretending Excel is a big sheet of magic graph paper. Try changing the year in the upper left corner, and watch the dates update automagically. When you’re done, print it out (turn on “grid lines” for a more structured look), pass around copies at your next meeting and enjoy the admiring glances from your peers for being so damn organized.

I imagine that these would be good for sketching-out multiple high-level, week-by-week project dependencies in a way that the Compact Calendar does not, as you can see overlapping threads of work more easily. Keep in mind, though, that the spreadsheet does not do project management software stuff like calculate dependencies, handle shifts in schedule, and all that stuff. This spreadsheet is a quick-and-dirty sketching tool only.

Visit the Manual Gantt Charting In Excel page to download the new files. The new zip archive is listed at the end of the post as a separate download. You’ll need Excel 2007 or newer to use the new spreadsheet.

9 Comments

  1. Will 9 years ago

    I’ve been looking for a Gantt tool like this for a lot of my side projects. Can’t wait to try it out.

  2. Julian 9 years ago

    Thanks David.. Really enjoyed your stuff – love my ipad + digital tech, but as your site makes clear, there is a time and place, when a sheet of paper + a nice pen is the best planning toolset!…

    Am using your weekly chart for cashflow forecasting my small law firm..

  3. Tom 8 years ago

    David, I have been trying out these weekly Gannt charts and really love them. I am starting to use them with a small team of people for multiple projects. One project has a 15 month timeline and it would be helpful to have it all on one chart. Right now I am just doing 4 months at a time. Your directions on the Gannt chart for how to extend the timeline are good and I think I can figure it out. I was just wondering if anyone had already done this. I am pretty new to Microsoft Excel :-(

  4. Ady Cooney 7 years ago

    Hi

    This is a very useful tool, I have been using this and wondered if there was any way of applying conditional rules to the spreadsheet, I want a rule to highlight the font Red in the relevant columns (Date) if the date is within 120 days of today.

    I can’t seem to do it.

    Can you help?

  5. Author
    Dave Seah 7 years ago

    Tom: Hopefully you figured out how to do it!

    Ady: You should be able to write a formula that uses the Excel TODAY() function. Something like: ABS(E6-TODAY())<120, where E6 contains the calculated date that is already in the spreadsheet. That will evaluate as TRUE 120 days before and afterwards.

  6. Ady Cooney 7 years ago

    Thanks Dave, unfortunately I still can’t make it work. Appreciate you trying.

  7. Author
    Dave Seah 7 years ago

    Ady: I had some trouble getting it to work until I saw that Excel was putting my formula in quotes.

    • Go to Conditional Formatting -> Manage Rules
    • Choose “Show Formatting Rules for This Worksheet”, click New Rule
    • Choose “Use a formula to determine which cells to format”
    • Enter =ABS(F$2-TODAY())<120 as the formula
    • Choose the format color, then click OK when you’re done
    • Apply formula to range $F$5:$ED$6

    That makes it work for my copy of Sample Gantt Daily.

  8. Ady Cooney 7 years ago

    Perfect, can’t thank you enough!

    Regards

    Ady

  9. Rob 7 years ago

    Hi Dave,

    Great template, I have two questions:

    1. How do adjust the formula to work monthly, instead of weekly? Using it for a 3 year roadmap.

    2. Is it possible to put all the subtasks in one row (instead of multiple rows underneath).