+ Post New Thread
Results 1 to 11 of 11
Office Software Thread, Excel - Gantt Chart Template in Technical; Hi all, If anybody has a spare Gantt Chart template for Excel I'd greatly appreciate it! (I'm looking for one ...
  1. #1
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44

    Excel - Gantt Chart Template

    Hi all,

    If anybody has a spare Gantt Chart template for Excel I'd greatly appreciate it! (I'm looking for one that's a daily timeline, hopefully split by weeks and displaying the day

    'Week 1' 'Week 2'
    'M T W T F' 'M T W T F'

    etc.

    Or if anybody has any other suggestions that'd be fab.

    Ta.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,506
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Don't have a template, but there are some details on the Office website on how to make a basic Gantt chart from a stacked bar chart which might get you started: Create a Gantt chart in Excel - Excel - Office.com

    Or there's a free template here (can't vouch for it I'm afraid. never used it): Free Gantt Chart Template for Excel

    Does it have to be done in Excel?

  3. #3
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44
    Quote Originally Posted by LosOjos View Post
    Don't have a template, but there are some details on the Office website on how to make a basic Gantt chart from a stacked bar chart which might get you started: Create a Gantt chart in Excel - Excel - Office.com

    Or there's a free template here (can't vouch for it I'm afraid. never used it): Free Gantt Chart Template for Excel

    Does it have to be done in Excel?
    Thanks and no it doesn't have to be in Excel. He (HT) said Excel (he has a printed Gantt Chart from a year ago that was apparently done in Excel) but I'm sure he won't refuse something alternative, as long as it's easy/ier to use

  4. #4


    Join Date
    May 2009
    Posts
    3,146
    Thank Post
    278
    Thanked 851 Times in 638 Posts
    Rep Power
    334
    I'd find yourself some open source project planning software such as taskjuggler (just an example - not particularly a recommendation). Gannt charts are not things in themselves (as such) - they are representations of operational networks (so called precedence or arrow methods, although I doubt many people have even heard of ADM these days). If you use them in anger, you need the network to make life easy when things (dates or even whole activities) change.

    I guess you could do a simple Gannt chart in excel with conditional formatting. So Col A would be description, B & C would be start and end dates. row 1 would have the dates and then columns D-ZZ could be conditionally formatted to 'light up' if their column date in row 1 is between the dates in the appropriate row in column B & C. Should take 10 mins to knock up ... in theory.

  5. #5


    Join Date
    May 2009
    Posts
    3,146
    Thank Post
    278
    Thanked 851 Times in 638 Posts
    Rep Power
    334
    Quote Originally Posted by pcstru View Post
    Should take 10 mins to knock up ... in theory.
    Seemed like a challenge.

    GanntSmlB.xlsx
    Last edited by pcstru; 5th June 2013 at 08:13 AM.

  6. Thanks to pcstru from:

    Fleetwood (5th June 2013)

  7. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,248
    Thank Post
    671
    Thanked 1,642 Times in 1,466 Posts
    Rep Power
    424
    I've used the one that was linked too and it worked fine.

    Ben

  8. #7
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44
    @pcstru that works great, thanks if I wanted to colour/'key' certain tasks/bars I assume that's also conditional formatting?

    I.E.: The A column has 'areas' (Finance, Marketing, Admin etc.) - could I somehow formulate so a bar will be red if any of the cells in A column contain 'Finance', blue for 'Marketing' etc.
    Last edited by Fleetwood; 5th June 2013 at 10:04 AM.

  9. #8


    Join Date
    May 2009
    Posts
    3,146
    Thank Post
    278
    Thanked 851 Times in 638 Posts
    Rep Power
    334
    Quote Originally Posted by TBlax View Post
    @pcstru that works great, thanks if I wanted to colour/'key' certain tasks/bars I assume that's also conditional formatting?

    I.E.: The A column has 'areas' (Finance, Marketing, Admin etc.) - could I somehow formulate so a bar will be red if any of the cells in A column contain 'Finance', blue for 'Marketing' etc.
    Sure. You can do it directly by adding a formula for each colour (as in the attached). Or if it will get much more complicated, I'd probably look at doing the analysis on the GLog tab and generating different numbers which then drives the conditional formatting. I think the latter is just a bit more ... manageable.
    Attached Files Attached Files

  10. Thanks to pcstru from:

    Fleetwood (5th June 2013)

  11. #9
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44
    That's great @pcstru, thanks a bunch! Just a final question (I'll stop after this haha,) the HT wants to have 'categories' so what I've done is just replaced some cells with a merged+centred subheading. Unfortunately this is going to be worked on as a 'may add more later' under each section, but I've noticed that if I try and insert a new row it does not follow through to the GLog sheet (I.E. it skips it, then moves down... if that makes sense.)

    See below, you'll get what I mean.

    chart.png
    (clicky)

    I've tried doing the CTRL+click on the Glog tab so it's also selected, then copying a 'blank' row within the formula to the category - but what happens is the row ABOVE the one I copy ends up duplicating across both of them.

    chartprob.png
    Last edited by Fleetwood; 5th June 2013 at 02:28 PM.

  12. #10


    Join Date
    May 2009
    Posts
    3,146
    Thank Post
    278
    Thanked 851 Times in 638 Posts
    Rep Power
    334
    You can get rid of the GLog sheet entirely and change the formula(s) in the conditional formatting to read like :

    =AND(AND(G$2>=$D4,G$2<=$E4),$B4="Marketing")

    Just do that in the G4 cell then copy that cell, select the block of the chart area and use paste special and select "formats" from the list. Now when you insert a row, the formats should copy from the row where you did the insert.

    GLog simply acts as an intermediate scratchpad. It would make it easier to do clever(er) things like different colours for progress or better formatting of the bars. I find editing conditional formats a bit of a pain (as soon as you move the cursor it starts putting in cell references), so I like to keep the calculations away from that.

  13. Thanks to pcstru from:

    Fleetwood (5th June 2013)

  14. #11
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44
    Oh I see! I'll give that a go and see what happens. Thanks for all your help on this, life saver lol!

    EDIT: Works perfectly! Cheers again.
    Last edited by Fleetwood; 5th June 2013 at 03:18 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Report Template in SIMS
    By landaufortecollege in forum MIS Systems
    Replies: 11
    Last Post: 9th December 2009, 03:47 PM
  2. gantt chart in excel
    By econtent in forum Windows
    Replies: 3
    Last Post: 21st April 2009, 04:30 PM
  3. Excel 2003 problem with chart...
    By kennysarmy in forum Windows
    Replies: 6
    Last Post: 12th December 2008, 07:04 PM
  4. Importing from Excel to CMIS templates
    By stevenwitthers in forum MIS Systems
    Replies: 1
    Last Post: 6th March 2008, 05:15 PM
  5. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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