+ Reply to Thread
Results 1 to 2 of 2

Read statistics and show on Chart

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Read statistics and show on Chart

    I work in a building firm where we bid on building jobs.

    We have no statistics to show how many we win or loose, nigther who we loose to or over.
    I would like to have a chart that gets updated every time we ad the results of our bid.

    I have a picture of the sheet where the info is put in.
    I have no idear of how to put up anything that will give me the statistics.

    What I am looking for is some sort of chart that will show:

    1. How often do we win? (If cell in collumn L says "VUNDET" then we have won, "TABT" Meens we have lost.
    2. Who do we win over and how often? The contractor we won over will be in Collumn O
    3. Who do we loose to and how often? The contractor we Loose to will be in Collumn O
    4. total sum of the wins for the top 3 contractors? Collumn M is our Bid, Collumn N is the bid of the contrator we either won or lost to.

    I am interestet in us and 4 other contractors, it is usally the same 4 to 6 contractors that bid on the jobs.

    I hope this gives some sort of meening and it is sufficient to help me in the right dirrection.
    If you have a better idear, please let me know.
    1.JPG
    Attached Files Attached Files
    Last edited by nordicdust; 07-13-2019 at 05:34 PM.

  2. #2
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Read statistics and show on Chart

    So I have made some changes and I have found out that it is Pivot tables and Pivot charts I need.
    Not something I done before, so I am clicking on everything and making a mess of the charts

    Here is what I am Trying to do.
    1. How often do we win?
    2. Who do we win over and how often?
    3. Who do we loose to and how often?
    4. total sum of the wins for the top 3 contractors?
    I don't expect it all to be on one chart, so something like a dashboard would be breat.

    I hope someone can guide me in the right direction.

    Table is changed to this now.
    Attachment 632403

+ 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. [SOLVED] VBA Button to Show all worksheets as READ ONLY
    By MissExcel86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2016, 08:23 AM
  2. Press a Button to Show They Have Read and When
    By Sal1tech in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2015, 02:18 AM
  3. Help Creating Chart from Statistics Data Set
    By sp1200 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-02-2012, 11:11 PM
  4. Chart and statistics
    By joelhuang in forum Excel General
    Replies: 11
    Last Post: 09-04-2012, 03:15 PM
  5. Replies: 1
    Last Post: 07-20-2012, 06:55 AM
  6. Create excel chart based on the output of Descriptive statistics
    By sanjee75 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2010, 08:50 PM
  7. Why Do My Documents Show As Read-Only For Others?
    By Vilja in forum Excel General
    Replies: 2
    Last Post: 08-17-2006, 03:01 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