+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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
    O365
    Posts
    20,419

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  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 n°1 and the time spent with method n°2.

    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)

Similar Threads

  1. PROCESS TRACKING-Process status should be Displayed base from the next blank Cell
    By RAMILJAYLDOMA in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2019, 09:17 AM
  2. listbox comparaison
    By Mundis06 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 08:20 AM
  3. [SOLVED] High-low-average chart with 3 lines per process
    By dreddster in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-09-2015, 03:31 AM
  4. Making an out of control process look different in SPC chart
    By blake.b.8726 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-05-2015, 11:26 AM
  5. Replies: 0
    Last Post: 11-10-2014, 10:52 AM
  6. Process Behaviour Chart (One line of data) - Any good ideas?
    By wintheranders in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2013, 03:48 AM
  7. Statistical Process Control chart
    By Tang Leep Boon in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-25-2011, 02:10 AM

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