+ Reply to Thread
Results 1 to 2 of 2

comparing the data and say which is better

  1. #1
    Registered User
    Join Date
    05-07-2020
    Location
    bangalore
    MS-Off Ver
    office365
    Posts
    4

    comparing the data and say which is better

    Hi,

    I got this list where there were tests happening on machines with different sets of process like 1-a running on s1 and it took 2hrs to complete where 1-b run on s2 machine took 8hrs. with this is there anyway I can show case the s1 is very good in comparison with others via graph/pivot table like this to my manager. the data is around 5000-7000 rows with different sets of process and servers. the data my manager wants to see is s1 is good than s2 when comparing the tasks on the same process.

    process task time taken server
    1 a 2 s1
    1 b 8 s2
    1 c 4 s1
    2 a 25 s3
    2 b 15 s2
    2 c 25 s2
    2 d 8 s1
    3 a 40 s5
    3 b 27 s5

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: comparing the data and say which is better

    Maybe like this:
    Attached Files Attached Files
    Click the * to say thanks.

+ 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. Replies: 0
    Last Post: 07-09-2017, 12:11 PM
  2. Replies: 5
    Last Post: 02-10-2016, 02:20 PM
  3. [SOLVED] Live graphing comparing manually entered data with existing data
    By Desert Coyote in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 05-15-2015, 03:05 PM
  4. [SOLVED] Data Analysis: Comparing 3 columns, sorting, removing unique values, display data
    By kmills2626 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 07:27 AM
  5. Replies: 1
    Last Post: 03-21-2013, 10:45 PM
  6. [SOLVED] Conditional formatting using Icon sets (comparing data to data in array)
    By darth.dims in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-27-2012, 05:36 AM
  7. Replies: 1
    Last Post: 11-22-2010, 07:03 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