+ Reply to Thread
Results 1 to 4 of 4

Gantt charts - help to tidy it up

  1. 08-12-2015, 03:25 PM #1
    nje
    nje is offline
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Gantt charts - help to tidy it up

    I have had my first attempt at a mocking up a Gantt chart, (I followed some instructions from youtube)
    I have uploaded a sample.
    If someone wouldn't mind taking a look I would appreciate it.
    It is quite a wide chart and a gap appears between cells 'W' & 'X'. Is there a way of closing that gap to make it look better?
    Also if there is a better more visually appealing way of doing a Gantt chart, could you point me in the right direction?
    Also if anyone has any advice on how to make my sample better, I'm all ears

    Thanks
    Neil
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-12-2015, 04:09 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Gantt charts - help to tidy it up

    The gap is there because you have it set to "Page View" Switch to Normal setting (View Tab). Alternately set it to fit on 1 page.

    Other than that, I have no issue with the appearance. From a practical standpoint, it's all manually entered. I would have another worksheet (same workbook) where project members enter Date (col A), Critical Task (Col B) and hours worked (Col C). Then have the formulas in the Gantt chart sum these up for you and put them in the right weeks. For example, in B5

    =SUMIFS(sheet2!$C$2:$C$5000, sheet2!$A$2:$A$5000, ">="&B$1, sheet2!$A$2:$A$5000, "<"&C$1, $C$2:$C$5000, $A5)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 08-12-2015, 04:36 PM #3
    nje
    nje is offline
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Re: Gantt charts - help to tidy it up

    ChemistB
    Thanks, sorry about the basic error with the page setting.
    I like the idea of automating a few things, but my first attempt at following your instructions hasn't quite worked out.
    I did the 3 columns on sheet two and put your formula in B5 (sheet 1) but it then returns a zero.
    Not really sure what I'm meant to put it the 'critical task' column. No doubt I haven't followed your instructions correctly. Unfortunately I've been summoned by her who must be obeyed and have to pack it in for now.
    I appreciate your advice and will have another go tomorrow.
    Thanks again
    Neil
    Reply With QuoteRegister To Reply
  4. 08-12-2015, 04:57 PM #4
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Gantt charts - help to tidy it up

    Here's an example. I entered the formula in B5:E9. You probably want to set formatting to not show 0's.
    I named a dynamic list on the Lists tab and used data validation to have dropdown menus with that list in column B of daily work
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Gantt charts for scheduling
    By Ram8516 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-25-2013, 02:19 AM
  2. Fun with Gantt charts
    By Juvenal in forum Excel General
    Replies: 0
    Last Post: 04-03-2012, 07:53 PM
  3. Gantt Charts done with Conditional Formatting
    By nielsoneo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2012, 02:25 PM
  4. help with autoshapes and gantt charts.
    By 0neup in forum Excel General
    Replies: 5
    Last Post: 09-22-2009, 05:08 AM
  5. Project Plan Creation in Excel (Gantt Charts)
    By leeb1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2008, 05:58 AM
  6. Gantt charts
    By Drew Cutter in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-25-2006, 06:10 PM
  7. [SOLVED] Time Increments in Gantt Charts
    By J Zentner in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2006, 08:20 PM
  8. OVERLAY TWO CHARTS(GANTT)
    By Mike in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-01-2005, 01:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1