QuantumCaveman
New Member
- Joined
- May 14, 2018
- Messages
- 1
Dear All,
As much as I love Excel and have mastered some elements of it...I am really struggling to produce a simple S-Curve chart and no matter where I look online I cant find a simple answer!
I want to display the 7 groups as different coloured lines along the x-axis of weeks starting wk1 thru to wk32 and y axis with 20 as total NCR's for each group and the s-curve showing each group progress ...
Can anyone please help?
<tbody>
</tbody>
As much as I love Excel and have mastered some elements of it...I am really struggling to produce a simple S-Curve chart and no matter where I look online I cant find a simple answer!
I want to display the 7 groups as different coloured lines along the x-axis of weeks starting wk1 thru to wk32 and y axis with 20 as total NCR's for each group and the s-curve showing each group progress ...
Can anyone please help?
WEEK | NON-CONFORMANCES | ||||||
Week | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 6 | Group 7 |
WK01 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
WK02 | 19 | 20 | 20 | 20 | 20 | 20 | 20 |
WK03 | 18 | 20 | 20 | 20 | 20 | 20 | 20 |
WK04 | 17 | 20 | 19 | 20 | 20 | 20 | 20 |
WK05 | 17 | 20 | 19 | 20 | 20 | 20 | 20 |
WK06 | 17 | 20 | 19 | 17 | 20 | 20 | 20 |
WK07 | 17 | 20 | 18 | 17 | 20 | 20 | 20 |
WK08 | 17 | 18 | 18 | 17 | 20 | 20 | 20 |
WK09 | 17 | 18 | 16 | 17 | 19 | 20 | 20 |
WK10 | 17 | 18 | 15 | 17 | 18 | 19 | 20 |
WK11 | 17 | 18 | 14 | 17 | 17 | 18 | 20 |
WK12 | 17 | 18 | 14 | 17 | 17 | 18 | 20 |
WK13 | 20 | 18 | 13 | 17 | 17 | 17 | 20 |
WK14 | 20 | 17 | 11 | 17 | 17 | 17 | 20 |
WK15 | 20 | 17 | 10 | 17 | 15 | 17 | 19 |
WK16 | 20 | 17 | 9 | 17 | 15 | 17 | 19 |
WK17 | 20 | 14 | 9 | 17 | 10 | 16 | 19 |
WK18 | 20 | 13 | 9 | 16 | 10 | 15 | 19 |
WK19 | 20 | 12 | 9 | 16 | 10 | 14 | 19 |
WK20 | 20 | 12 | 8 | 15 | 9 | 14 | 19 |
WK21 | 20 | 12 | 7 | 15 | 9 | 13 | 19 |
WK22 | 20 | 12 | 6 | 15 | 9 | 13 | 18 |
WK23 | 20 | 12 | 6 | 15 | 8 | 13 | 18 |
WK24 | 20 | 12 | 6 | 15 | 8 | 13 | 18 |
WK25 | 20 | 12 | 5 | 15 | 8 | 13 | 17 |
WK26 | 20 | 12 | 5 | 15 | 7 | 13 | 17 |
WK27 | 20 | 9 | 5 | 15 | 7 | 12 | 17 |
WK28 | 20 | 9 | 5 | 14 | 7 | 12 | 17 |
WK29 | 20 | 8 | 4 | 13 | 7 | 12 | 16 |
WK30 | 20 | 8 | 4 | 12 | 7 | 12 | 16 |
WK31 | 20 | 8 | 4 | 12 | 7 | 12 | 16 |
WK32 | 10 | 7 | 4 | 11 | 7 | 12 | 16 |
<tbody>
</tbody>