Hi!
I have 8 technicians and would like to create a chart to track how many of the issues they're working on are in compliance and out of compliance at the end of each week. I've been collecting the data but can't get it to show me on a chart correctly without it doing something weird like summing the numerical value of the date, etc.
Ideally I'd like to it do:
a 3D stacked column of in-compliance (IC) and out-of-compliance (OC) grouped by date
the bottom axis would be the name of the tech
the left and back side axis would be the number of items
the percentage of issues in compliance vs the total would show up as well as another series I guess?
My data looks like this (kinda):
I'd love to learn how to make this work, if someone's really bored I can paypal you $10 of beer money for your time if you can show me a working copy and explain how you got there
Thanks!
I have 8 technicians and would like to create a chart to track how many of the issues they're working on are in compliance and out of compliance at the end of each week. I've been collecting the data but can't get it to show me on a chart correctly without it doing something weird like summing the numerical value of the date, etc.
Ideally I'd like to it do:
a 3D stacked column of in-compliance (IC) and out-of-compliance (OC) grouped by date
the bottom axis would be the name of the tech
the left and back side axis would be the number of items
the percentage of issues in compliance vs the total would show up as well as another series I guess?
My data looks like this (kinda):
| Excel 2013 | |||||||
|---|---|---|---|---|---|---|---|
| C | D | E | F | G | |||
| 3 | Tech | IC | OC | % | Date | ||
| 4 | Tech 1 | 5 | 1 | 83% | 9/26/2014 | ||
| 5 | Tech 2 | 4 | 1 | 80% | |||
| 6 | Tech 3 | 8 | 4 | 67% | |||
| 7 | Tech 4 | 1 | 0 | 100% | |||
| 8 | Tech 5 | 13 | 0 | 100% | |||
| 9 | Tech 6 | 0 | 4 | 0% | |||
| 10 | Tech 7 | 17 | 14 | 55% | |||
| 11 | Tech 8 | 3 | 0 | 100% | |||
| 12 | Tech 1 | 1 | 0 | 100% | 10/3/2014 | ||
| 13 | Tech 2 | 1 | 4 | 20% | |||
| 14 | Tech 3 | 3 | 2 | 60% | |||
| 15 | Tech 4 | 1 | 0 | 100% | |||
| 16 | Tech 5 | 9 | 0 | 100% | |||
| 17 | Tech 6 | 3 | 1 | 75% | |||
| 18 | Tech 7 | 8 | 3 | 73% | |||
| 19 | Tech 8 | 2 | 2 | 50% | |||
| 20 | Tech 1 | 0 | 1 | 0% | 10/10/2014 | ||
| 21 | Tech 2 | 7 | 0 | 100% | |||
| 22 | Tech 3 | 3 | 3 | 50% | |||
| 23 | Tech 4 | 1 | 0 | 100% | |||
| 24 | Tech 5 | 9 | 0 | 100% | |||
| 25 | Tech 6 | 1 | 4 | 20% | |||
| 26 | Tech 7 | 1 | 8 | 11% | |||
| 27 | Tech 8 | 2 | 0 | 100% | |||
Sheet1 | |||||||
I'd love to learn how to make this work, if someone's really bored I can paypal you $10 of beer money for your time if you can show me a working copy and explain how you got there
Thanks!
