+ Reply to Thread
Results 1 to 5 of 5

Process comparaison chart

  1. #1
    Registered User
    Join Date
    07-11-2019
    Location
    France
    MS-Off Ver
    2016
    Posts
    2

    Process comparaison chart

    Hi everyone,

    I am trying to make a chart to compare two pproduction process.

    I would like to be able to gather in a chart several tasks for which, I compare the time realized for each task between my two methods of production.

    There is a simple example of my datas.


    Production time Developement time
    Task 1 Process 1 1 day
    Process 2 1 hour 1.5 day

    Task 2 Process 1 4 hours
    Process 2 30 minutes 1 day

    Task 3 Process 1 2 hours
    Process 2 1 hour 3 hours


    Thank you for your help.

  2. #2
    Forum Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    7,210

    Re: Process comparaison chart

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,432

    Re: Process comparaison chart

    Here is one way.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    27,600

    Re: Process comparaison chart

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Registered User
    Join Date
    07-11-2019
    Location
    France
    MS-Off Ver
    2016
    Posts
    2

    Re: Process comparaison chart

    I am sorry if my request wasn't clear. But I don't think to attach a workbook can help you to understand my desired result, because I am looking for a good representation for a production process.


    Indeed, I would like to use an excel chart to show between several tasks, witch time it's took with a method n1 and the time spent with method n2.

    I fact, I just want to do a Gantt Chart, but with comparing two methods for each tasks.

+ 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