+ Reply to Thread
Results 1 to 4 of 4

Glitch on Gantt chart

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    Lancaster, England
    MS-Off Ver
    2013
    Posts
    3

    Glitch on Gantt chart

    Hi,

    I've created a Gantt Chart to display the activities of individuals with a learning disability in a supported living house. The chart has a time range from 6am to midnight, with a column for each 15 minute increment between the two times, with 7 rows, one for each day of the week. Any activities that are input in a separate section will appear on the Gantt chart. This is done by using an IF(AND formula to see if a time falls between the start time and end time of the activity. If it does, it will appear as a 1 on the grid, otherwise a 0. Using a conditional format, this will appear as a green block. So, an activity between 08:00-09:00 will appear as a bar of four columns under the relevant time.

    The formula seems to work fine apart from one issue which I can seem to get right. If the activity covers a time period after 10pm, the bar is one column short, so a time period from 20:00-22:00 stops at 21:45. If I double-click into the cell with 22:00 (BO20) on the Gantt chart and then click out of it, the problem is corrected, so I don't think it is a formula error

    |However, the formula I'm using is:

    IF(AND($E$4=$A$195,BO$20>=$F$4,BO$19<=$H$4)),1,0

    E4 is the type of activity, relating to A195 (a code, not relevant to the issue though)
    F4 is the start time (20:00), H4 is the end time (22:00)

    BO20 is 21:45 on the Gantt chart, BO19 is 22:00 (text is oriented to a 90 degree angle)

    If there's not a problem with the formula, is it time format issue, currently [h]:mm

    any advice will be gratefully received

    Jed
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,896

    Re: Glitch on Gantt chart

    There's no image attached (that I can see). In any event, an Excel sheet is more useful...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-30-2015
    Location
    Lancaster, England
    MS-Off Ver
    2013
    Posts
    3

    Re: Glitch on Gantt chart

    sorry, thought I had done, should be attached now
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-30-2015
    Location
    Lancaster, England
    MS-Off Ver
    2013
    Posts
    3

    Re: Glitch on Gantt chart

    Anyone? This is an infuriating glitch!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  2. Font glitch when copying chart exis label?
    By seanspotatobusiness in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-24-2014, 11:09 AM
  3. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  4. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  5. Gantt Chart
    By dwalton5 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2012, 06:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1