+ Reply to Thread
Results 1 to 10 of 10

Timeline or Gantt Chart with times by minutes/hours rather than days

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Timeline or Gantt Chart with times by minutes/hours rather than days

    Hi there

    I'm looking to create a timeline or Gantt chart with times by minutes/hours rather than days. I've seen several templates in Excel but all have days. I've tried editing them to change to hours and minutes but it doesn't work. If possible, I'd prefer the markers to clearly to show the gaps proportionally (i.e. if the first milestone is 5 minutes, second 10 minutes and third is 1 hour, I would prefer they weren't equal distance apart).

    Any ideas where I could find a template or create my own document?

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    Hi
    Have a look at this link:
    http://office.microsoft.com/en-gb/ex...001034605.aspx
    Good luck.
    Tony

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    I still haven't managed to resolve this issue. I basically want a chart (similar to the one attached) but have minutes and hours rather than days. Any suggestions?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    Quote Originally Posted by ARGK View Post
    Hi
    Have a look at this link:
    http://office.microsoft.com/en-gb/ex...001034605.aspx
    Good luck.
    Tony
    Thanks but this chart doesn't seem to work in hours.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    You will need to use xy-scatter in order to get time.

    change chart types and adjust data ranges. Other major thing is you now need to link data labels to cells in order to get milestone text.

    You can do that with a free addin
    http://www.appspro.com/Utilities/ChartLabeler.htm
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    Thank you Andy Pope. Your solution has resolved my issue.

  7. #7
    Registered User
    Join Date
    08-05-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    it was very helpful...

  8. #8
    Registered User
    Join Date
    04-14-2005
    Posts
    3

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    Quote Originally Posted by Andy Pope View Post
    You will need to use xy-scatter in order to get time.

    change chart types and adjust data ranges. Other major thing is you now need to link data labels to cells in order to get milestone text.

    You can do that with a free addin
    http://www.appspro.com/Utilities/ChartLabeler.htm
    How hard would it be to make this chart as it is but show the duration of some of the items, like a standard Gantt but still have the position option? Or would it have to be made from a bar chart?

    Task Start Time End Time Duration Position
    Build Box 0700 0900 2.0 hrs 15
    Load 0930 1000 .5 hrs 10
    Depart 1100 1100 .0 hrs 5
    Last edited by emm; 05-31-2014 at 07:50 PM. Reason: was going to try to put data in a table but ...

  9. #9
    Registered User
    Join Date
    06-26-2019
    Location
    dallas
    MS-Off Ver
    365
    Posts
    1

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    I would like to download this but it will not allow me.

  10. #10
    Registered User
    Join Date
    01-13-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    1

    Re: Timeline or Gantt Chart with times by minutes/hours rather than days

    Quote Originally Posted by dvs View Post
    I still haven't managed to resolve this issue. I basically want a chart (similar to the one attached) but have minutes and hours rather than days. Any suggestions?
    Can you share the file with me? For some reason I cannot download it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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