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 ...
4th June 2013, 04:23 PM #1
Excel - Gantt Chart Template
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'
Or if anybody has any other suggestions that'd be fab.
4th June 2013, 04:26 PM #2
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?
4th June 2013, 05:39 PM #3
4th June 2013, 06:57 PM #4
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.
5th June 2013, 08:11 AM #5
Seemed like a challenge.
Originally Posted by pcstru
Last edited by pcstru; 5th June 2013 at 08:13 AM.
5th June 2013, 08:20 AM #6
I've used the one that was linked too and it worked fine.
5th June 2013, 09:31 AM #7
@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 TBlax; 5th June 2013 at 10:04 AM.
5th June 2013, 12:01 PM #8
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.
Originally Posted by TBlax
5th June 2013, 02:15 PM #9
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.
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.
Last edited by TBlax; 5th June 2013 at 02:28 PM.
5th June 2013, 02:48 PM #10
You can get rid of the GLog sheet entirely and change the formula(s) in the conditional formatting to read like :
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.
5th June 2013, 02:59 PM #11
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 TBlax; 5th June 2013 at 03:18 PM.
By landaufortecollege in forum MIS Systems
Last Post: 9th December 2009, 03:47 PM
By econtent in forum Windows
Last Post: 21st April 2009, 04:30 PM
By kennysarmy in forum Windows
Last Post: 12th December 2008, 07:04 PM
By stevenwitthers in forum MIS Systems
Last Post: 6th March 2008, 05:15 PM
By wesleyw in forum How do you do....it?
Last Post: 12th September 2007, 11:01 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)