gantt question (diagonal candidate?)
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: gantt question (diagonal candidate?)

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    i am using the mullins steel boat example(conditional formatting) as the base for the following:
    code start end 19:00 19:10 19:20
    48 20:00 20:30
    39 20:30 20:45
    31 20:45 21:50
    39 21:50 22:00
    43 22:00 22:20
    where a user enters a code and the the start and end time, then bars are highlighted corresponding with the block of time represented (using the conditional formula =AND(D$1>=$B2,D$1<=$C2)). what i want is for the user to enter a coded start and end and then display the corresponding time block on a single line, color coded by code. so mabey code 31 is yellow, and 48 is green. the times will not overlap, but there may be gaps between one codes end and the next sequential start.

    thanks,
    eric



  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    not sure what the "diagonal" is that you're referring to, but the Gannt chart uses 3 conditions to plot the bars

    plotting them in colours according to code would mean a fourth condition, which exceeds the amount of conditions in conditional format

    However, I believe the many VBA experts may be able to code a way around this, so I'll chuck this post back to the top for ya

    Hope this helps, albeit probably negatively
    Chris

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    to clarify, i want users to enter codes (like 31,48,34,39,43 etc.) with a start and end time, and have it plotted on a single time line, with each code being a unique color

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yup, your bar in the chart uses up 3 conditions

    >= start time
    > start time and < end time
    <= end time

    conditional format only allows 3 conditions

    further colouring any bar based on a fourth exceeds this capacity

    (ummm, I think)

    I've read that this can be overcome via VBA but my knowledge of VBA is about as reliable as a Zimbabwean Election Co-ordinator....

    [ This Message was edited by: Chris Davison on 2002-03-13 15:55 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    common guys.... no one has any ideas??


    [ This Message was edited by: ercstric on 2002-03-13 19:40 ]

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    any vba ninjas out there got some code for this?


  7. #7
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i am open to any other formats that could accomplish the single line gantt. so if you are holding back because of my original format -- DONT!

    eric

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    .


    [ This Message was edited by: ercstric on 2002-03-14 17:44 ]

  9. #9
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Emailed your workbook.....note code
    only applicable to the range you had set out
    in the sheet......


    HTH

    Ivan

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Eric,

    I do have a messy workaround that is non-VBA which satisfies as many colours as you have in your background pattern palette (and thus around 40 of your codes) but it's a real pain in the backside.

    in the very unlikely occurance of Ivan not being able to sort you out, repost and I'll type it all out.

    it's basically extending conditional format beyond the 3 normal colours but is a real last resort

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com