+ Reply to Thread
Results 1 to 3 of 3

Gantt Chart with multiple Days

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Newyork ,New york
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Gantt Chart with multiple Days

    Hi Experts ,
    Need your help to resolve my issue in gantt chart.
    My requirement is build a report which contains the start and end time of 3 jobs.

    I am able to do it for a single day but failed to do it for multiple days . Not able to attach the excel for your reference.

    Unix_forum.PNG
    Last edited by deep_kol; 08-10-2017 at 04:06 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Job Stats Daily and weekly Basis

    Thanks for changing the title.
    Last edited by protonLeah; 08-10-2017 at 04:12 PM.
    Ben Van Johnson

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Gantt Chart with multiple Days

    It should not really be any different for data spanning more than one day than for data on a single day. If the max value for the horizontal axis is set to "midnight of next day", then you may need to change that value to be something more appropriate. Or maybe you just need to change the number format on the axis to show day and time or elapsed time. I would expect that, other than some minor formatting changes like this, the fundamental parts of the Gantt chart (data and chart elements) should be the same.

    In order to upload a sample file, click on go advanced, find the "manage attachments" link, and use the site's uploader to upload and attach your file to the post.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  2. Replies: 1
    Last Post: 02-28-2014, 02:31 AM
  3. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  4. Replies: 1
    Last Post: 03-21-2013, 10:45 PM
  5. Calculating overtime hours on a daily and weekly basis
    By Skwerl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2011, 09:12 PM
  6. Need to sum number of error by weekly and daily basis
    By marc5354 in forum Excel General
    Replies: 2
    Last Post: 11-03-2010, 11:04 AM
  7. Need to count productivity by weekly and daily basis
    By marc5354 in forum Excel General
    Replies: 4
    Last Post: 10-06-2010, 01:36 PM

Tags for this Thread

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