Hi,
I have (410 line) data like the sample attached below. Need VBA code to create a shale chart. With Unit being the various areas and End by being the X-axis.
Logic: All units put together totally there are 410 people. With 17 people having end by P1, 410 will get reduced by 17 in P02.
this logic has to be applied per unit and plotted in shale.
I have (410 line) data like the sample attached below. Need VBA code to create a shale chart. With Unit being the various areas and End by being the X-axis.
Logic: All units put together totally there are 410 people. With 17 people having end by P1, 410 will get reduced by 17 in P02.
this logic has to be applied per unit and plotted in shale.
| Excel 2013/2016 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Name | Unit | End by | ||
| 2 | First Name 1 | Central Team | P01 | ||
| 3 | First Name 2 | Central Team | P02 | ||
| 4 | First Name 3 | Customer | P03 | ||
| 5 | First Name 4 | Customer | P04 | ||
| 6 | First Name 5 | Customer | P05 | ||
| 7 | First Name 6 | Customer | P07 | ||
| 8 | First Name 7 | Customer | P08 | ||
| 9 | First Name 8 | Customer | P12 | ||
| 10 | First Name 9 | Customer | P10 | ||
| 11 | First Name 10 | Customer | P12 | ||
| 12 | First Name 11 | Customer | P12 | ||
| 13 | First Name 12 | Customer | P12 | ||
| 14 | First Name 13 | Customer | P02 | ||
| 15 | First Name 14 | Customer | P06 | ||
| 16 | First Name 15 | Customer | P04 | ||
| 17 | First Name 16 | Customer | P12 | ||
| 18 | First Name 17 | Customer | P12 | ||
| 19 | First Name 18 | Customer | P08 | ||
| 20 | First Name 19 | Customer | P12 | ||
| 21 | First Name 20 | Customer | P10 | ||
| 22 | First Name 21 | Customer | P12 | ||
| 23 | First Name 22 | Customer | P12 | ||
| 24 | First Name 23 | Customer | P12 | ||
| 25 | First Name 24 | Customer | P02 | ||
| 26 | First Name 25 | Customer | P08 | ||
| 27 | First Name 26 | Customer | P04 | ||
| 28 | First Name 27 | Customer | P12 | ||
| 29 | First Name 28 | Customer | P12 | ||
| 30 | First Name 29 | Customer | P08 | ||
| 31 | First Name 30 | Customer | P12 | ||
| 32 | First Name 31 | Customer | P10 | ||
| 33 | First Name 32 | Customer | P12 | ||
| 34 | First Name 33 | Customer | P12 | ||
| 35 | First Name 34 | Customer | P12 | ||
| 36 | First Name 35 | Customer | P02 | ||
| 37 | First Name 36 | Customer | P12 | ||
| 38 | First Name 37 | Customer | P04 | ||
| 39 | First Name 38 | Customer | P12 | ||
| 40 | First Name 39 | Customer | P12 | ||
| 41 | First Name 40 | Customer | P08 | ||
| 42 | First Name 41 | Customer | P12 | ||
| 43 | First Name 42 | Customer | P10 | ||
| 44 | First Name 43 | Customer | P12 | ||
| 45 | First Name 44 | Customer | P08 | ||
| 46 | First Name 45 | Customer | P12 | ||
| 47 | First Name 46 | Customer | P02 | ||
| 48 | First Name 47 | Customer | P12 | ||
| 49 | First Name 48 | Customer | P04 | ||
| 50 | First Name 49 | Customer | P12 | ||
| 51 | First Name 50 | Customer | P12 | ||
| 52 | First Name 51 | Customer | P08 | ||
| 53 | First Name 52 | Customer | P12 | ||
| 54 | First Name 53 | Customer | P10 | ||
| 55 | First Name 54 | Customer | P11 | ||
| 56 | First Name 55 | Customer | P12 | ||
| 57 | First Name 56 | Customer | P01 | ||
| 58 | First Name 57 | Customer | P02 | ||
| 59 | First Name 58 | Customer | P03 | ||
| 60 | First Name 59 | Customer | P04 | ||
| 61 | First Name 60 | Customer | P05 | ||
| 62 | First Name 61 | Customer | P07 | ||
| 63 | First Name 62 | Customer | P08 | ||
| 64 | First Name 63 | Customer | P09 | ||
| 65 | First Name 64 | Customer | P10 | ||
| 66 | First Name 65 | Customer | P11 | ||
| 67 | First Name 66 | Customer | P12 | ||
| 68 | First Name 67 | Customer | P01 | ||
| 69 | First Name 68 | Customer | P02 | ||
| 70 | First Name 69 | Customer | P03 | ||
| 71 | First Name 70 | Customer | P04 | ||
| 72 | First Name 71 | Customer | P05 | ||
| 73 | First Name 72 | Customer | P07 | ||
| 74 | First Name 73 | Customer | P08 | ||
| 75 | First Name 74 | Customer | P09 | ||
| 76 | First Name 75 | Customer | P10 | ||
| 77 | First Name 76 | Customer | P11 | ||
| 78 | First Name 77 | Customer | P12 | ||
| 79 | First Name 78 | Customer | P01 | ||
| 80 | First Name 79 | Customer | P02 | ||
| 81 | First Name 80 | Customer | P12 | ||
| 82 | First Name 81 | Customer | P04 | ||
| 83 | First Name 82 | Customer | P12 | ||
| 84 | First Name 83 | Customer | P12 | ||
| 85 | First Name 84 | Networks | P08 | ||
| 86 | First Name 85 | Networks | P12 | ||
| 87 | First Name 86 | Networks | P10 | ||
| 88 | First Name 87 | Networks | P12 | ||
| 89 | First Name 88 | Networks | P12 | ||
| 90 | First Name 89 | Networks | P12 | ||
| 91 | First Name 90 | Networks | P02 | ||
| 92 | First Name 91 | Networks | P12 | ||
| 93 | First Name 92 | Networks | P04 | ||
| 94 | First Name 93 | Networks | P12 | ||
| 95 | First Name 94 | Networks | P12 | ||
| 96 | First Name 95 | Networks | P08 | ||
| 97 | First Name 96 | Networks | P12 | ||
| 98 | First Name 97 | Networks | P10 | ||
sheet2 | |||||
Last edited by a moderator:
