+ 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
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Glitch on Gantt chart

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



  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