Spreadsheet: 139669d1328373729-please-help-me-with-this-chart-not-sure-where-to-start-pivotchartmachinedowntime
Sheet: Sheet1

Date | Machine | Reason | DownTime Min |  | Prob List
 |  |  |  |  | die |  | This is a pivot chart answer.  I hope your 2007 Excel can filter the Day, Machine and reason.
 |  |  |  |  | material |  | You will do better with a stacked bar.
 |  |  |  |  | conveyor
 |  |  |  |  | guide Pin
 |  |  |  |  | weighting
 |  |  |  |  |  |  | Sum of DownTime Min | Column Labels
 |  |  |  |  |  |  |  | Machine 1 |  |  |  |  | Machine 1 Total | Machine 2 |  |  |  | Machine 2 Total | Machine 3 |  |  |  |  | Machine 3 Total | Machine 4 |  |  |  |  | Machine 4 Total | Machine 5 |  |  |  | Machine 5 Total | Machine 6 |  |  |  |  | Machine 6 Total | Machine 7 |  |  |  | Machine 7 Total | Machine 8 |  |  |  |  | Machine 8 Total | Machine 9 |  |  |  |  | Machine 9 Total | Grand Total
 |  |  |  |  |  |  | Row Labels | conveyor | die | guide Pin | material | weighting |  | die | guide Pin | material | weighting |  | conveyor | die | guide Pin | material | weighting |  | conveyor | die | guide Pin | material | weighting |  | conveyor | die | guide Pin | material |  | conveyor | die | guide Pin | material | weighting |  | conveyor | die | guide Pin | weighting |  | conveyor | die | guide Pin | material | weighting |  | conveyor | die | guide Pin | material | weighting
 |  |  |  |  |  |  | 2012-02-01 00:00:00 |  |  |  |  |  |  |  | 3 |  |  | 3 | 8 |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 6 |  | 6 |  |  |  |  |  |  |  | 6 |  |  | 6 |  |  |  |  |  |  |  | 6 |  |  |  | 6 | 29
 |  |  |  |  |  |  | 2012-02-02 00:00:00 |  |  |  | 12 |  | 12 | 8 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 |  |  |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 15 | 15 | 62
 |  |  |  |  |  |  | 2012-02-03 00:00:00 | 11 |  | 6 | 8 | 9 | 34 |  | 7 |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 |  | 1 |  |  |  | 1 |  |  |  |  |  |  | 52
 |  |  |  |  |  |  | 2012-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 7 | 10 |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  | 7 |  |  | 7 |  |  |  |  |  |  | 14 |  |  |  | 14 |  |  |  |  |  |  | 32
 |  |  |  |  |  |  | 2012-02-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 16 | 25 |  | 6 |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 2012-02-06 00:00:00 |  |  | 15 | 15 |  | 30 |  |  | 5 |  | 5 |  |  |  |  |  |  |  |  | 6 |  |  | 6 |  | 10 |  |  | 10 |  |  |  |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  | 2012-02-07 00:00:00 |  |  | 7 |  |  | 7 |  |  | 11 |  | 11 |  |  | 13 |  |  | 13 |  |  |  |  |  |  |  |  | 15 |  | 15 |  |  | 14 |  |  | 14 |  |  |  |  |  |  |  |  |  | 14 | 14 | 10 |  |  |  | 5 | 15 | 89
 |  |  |  |  |  |  | 2012-02-08 00:00:00 |  |  |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 |  |  |  |  |  |  |  |  | 7 |  |  | 7 | 23
 |  |  |  |  |  |  | 2012-02-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 |  |  | 6 |  |  | 13 |  | 13 |  |  | 14 | 17 |  | 31 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  | 2012-02-10 00:00:00 |  | 11 |  |  |  | 11 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 21 |  |  |  | 21 | 36
 |  |  |  |  |  |  | 2012-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 8 | 10 | 11 |  |  |  | 11 |  |  |  |  |  |  |  | 6 |  |  |  | 6 | 27
 |  |  |  |  |  |  | 2012-02-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 11 | 13 |  |  |  |  | 13 |  | 9 |  |  | 9 |  | 2 |  |  |  | 2 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 2012-02-13 00:00:00 |  |  |  | 10 |  | 10 | 5 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 2012-02-14 00:00:00 |  |  |  |  |  |  |  | 9 |  |  | 9 | 11 |  |  | 1 |  | 12 | 7 | 2 |  |  |  | 9 |  |  |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | 12 |  |  |  |  |  |  | 46
 |  |  |  |  |  |  | 2012-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  | 11 | 6 |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  | 3 |  | 3 | 31
 |  |  |  |  |  |  | 2012-02-16 00:00:00 |  | 13 |  |  |  | 13 |  | 12 |  |  | 12 |  |  |  |  |  |  |  |  | 15 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 5 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 2012-02-17 00:00:00 |  |  |  |  |  |  | 7 |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 10 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 2012-02-18 00:00:00 |  |  |  |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  | 12 | 14 | 26 |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 2012-02-19 00:00:00 |  |  |  | 16 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 8 | 20 | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  | 13 | 18 | 31 |  |  | 2 |  |  | 2 |  |  |  |  |  |  | 71
 |  |  |  |  |  |  | 2012-02-20 00:00:00 |  |  |  | 15 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 9 |  |  |  | 12 |  | 12 | 36
 |  |  |  |  |  |  | 2012-02-21 00:00:00 |  |  |  | 5 |  | 5 |  |  |  |  |  |  | 19 |  |  |  | 19 |  | 10 |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  | 36
 |  |  |  |  |  |  | 2012-02-22 00:00:00 | 8 | 9 |  | 1 |  | 18 |  |  |  |  |  |  | 13 |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 13 | 28 |  |  |  | 5 | 5 |  |  |  |  |  |  |  | 14 |  |  |  | 14 | 78
 |  |  |  |  |  |  | 2012-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  | 11 | 23
 |  |  |  |  |  |  | 2012-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 12 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 2012-02-25 00:00:00 |  |  |  |  |  |  |  |  |  | 7 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 2012-02-26 00:00:00 |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 2012-02-27 00:00:00 |  |  | 10 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 2012-02-28 00:00:00 | 12 |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | 22 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 2012-02-29 00:00:00 |  |  |  |  |  |  |  | 3 | 8 |  | 11 |  |  | 4 |  |  | 4 |  |  |  |  |  |  |  | 2 |  | 3 | 5 |  |  |  | 10 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 7 | 37
 |  |  |  |  |  |  | Grand Total | 31 | 33 | 38 | 82 | 14 | 198 | 20 | 35 | 25 | 8 | 88 | 33 | 35 | 17 | 10 | 23 | 118 | 14 | 31 | 33 | 12 | 20 | 110 | 2 | 12 | 32 | 29 | 75 | 15 | 3 | 24 | 51 | 40 | 133 | 11 | 15 | 26 | 47 | 99 | 24 | 21 | 52 | 17 | 26 | 140 | 21 | 47 | 7 | 22 | 20 | 117 | 1078