+ Reply to Thread
Results 1 to 2 of 2

Need to create Stacked Graph with time as x -axis

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    8

    Need to create Stacked Graph with time as x -axis

    I have some data as shown below:

    ID Process Start Process Step one completed All Steps Complete
    10 A 6/19/2012 18:32 6/19/2012 21:31 6/20/2012 0:14
    10 B 6/20/2012 0:13 6/20/2012 0:24 6/20/2012 1:27
    20 A 6/19/2012 18:31 6/19/2012 18:40 6/19/2012 22:22
    20 B 6/19/2012 22:22 6/19/2012 22:30 6/19/2012 23:30
    30 A 6/19/2012 19:32 6/19/2012 21:21 6/20/2012 1:38
    30 B 6/20/2012 1:38 6/20/2012 1:47 6/20/2012 1:54

    I need to create a graph with time as x-axis & ID as Y-axis. ID has multiple rows.

    For example : For ID 10, Process A starts at 6/19/2012 18:32 , Step one gets completed at 6/19/2012 21:31 and the entire process gets completed at 6/20/2012 0:14. As soon as Process A stops, Process B for the same ID (10) starts: 6/20/2012 0:13 . Step one for process B gets completed at 6/20/2012 0:24 and all the steps gets completed at 6/20/2012 1:27

    So for ID 10, I want a stacked bar graph with time as x-axis & time taken by each process stacked one after other.

    Attached is a sample excel sheet & the jpg of the expected graph

    Any help is greatly appreciated.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Need to create Stacked Graph with time as x -axis

    You need to calculate the durations between the events and plot the durations stacked on the first date. See attached.
    Attached Files Attached Files
    Like a post? Click the star below 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