+ Reply to Thread
Results 1 to 2 of 2

convert excel data into a time line bar graph

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    convert excel data into a time line bar graph

    An example of the excel data:

    The columns below are Code, Code Name, Start time, End Time, Modifier Name

    33157437 edepp 2/12/02 9:13:00 AM 2/12/02 9:13:00 AM jpm
    33124494 ICRTT 2/12/02 9:14:59 AM 2/12/02 9:17:39 AM dhs
    33200437 oerd 2/12/02 9:17:28 AM 2/12/02 9:18:03 AM cer
    33689382 oerd 2/12/02 9:22:21 AM 2/12/02 9:22:30 AM cr2
    33879897 poerr 2/12/02 9:24:51 AM 2/12/02 9:35:26 AM dtd
    34112763 ares 2/12/02 9:28:43 AM 2/12/02 9:28:44 AM cer
    34127763 ibris 2/12/02 9:29:10 AM 2/12/02 9:29:10 AM mdb
    34081197 porii 2/12/02 9:29:12 AM 2/12/02 9:29:12 AM ejt
    34096229 oerd 2/12/02 9:29:16 AM 2/12/02 9:29:17 AM vee
    34208197 smrs 2/12/02 9:30:35 AM 2/12/02 9:32:39 AM bkh
    34386494 smrs 2/12/02 9:33:22 AM 2/12/02 9:33:38 AM bkh
    34438162 smrs 2/12/02 9:34:15 AM 2/12/02 9:34:29 AM bkh
    34480835 smrs 2/12/02 9:35:00 AM 2/12/02 9:35:10 AM bkh
    34407264 icrii 2/12/02 9:35:02 AM 2/12/02 9:35:06 AM jdw
    34539437 glej 2/12/02 9:35:43 AM 2/12/02 9:35:44 AM ajc


    Does anyone here know how to convert those excel data into an appropriate data format which can be convert into time graph? For instance (not in a precise graph):


    33157437 |--jpm-|

    34096229 |---------------vee-----------------|

    34539437 |-------------------------ajc------------------------|

    1/1 2/1 3/1 4/1 ....

    10:00 12:00 14:00 16:00 ....



    Any information would be appreciate!

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

    Re: convert excel data into a time line bar graph

    search the forum for "Gantt" charts
    Cheers
    Andy
    www.andypope.info

+ 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