+ Reply to Thread
Results 1 to 1 of 1

Pivot chart+table unsure how to layout and get to do what i need

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Hereford
    MS-Off Ver
    Home and Business 2016
    Posts
    17

    Pivot chart+table unsure how to layout and get to do what i need

    Hi , so with my spreadsheet the idea of it is that our machines have a set amount of hours we expect it to be ran unmanned (This is shown as the estimate time row highlighted red) we are then asking one of our workers to predict what he believes the time will be for the week (Jim prediction row) and i'm also wanting a section where he can put a comment under each machine as to why this time is what he thinks. The last thing that i need to be shown is the actual time that the machine ran unmanned. this is what would need to be in the table and i'm unsure on how to lay it out as i would need to have this with a week field aswell to have it be picked up on the graph.

    With the graph im wanting it to pick out the estimate time which is a set number that wont change and then pick up the actual time, with the graph we won't be showing the Jim prediction row but would like it to be shown in the table still, on sheet 3 you can see what i have done with the first table but that doesnt work for me as i dont want to be having to copy all the machine names each time and week number as if there are 3 week of data for "MULT1" i need that to be shown all under the one machine on the graph and not have 3 cases of "MULT1" showing, hope this makes sense.
    Attached Files Attached Files

+ 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