Help create a Shale chart

[Nitya0808]

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.

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

 

[shg]

What is "shale"?

 

[Nitya0808]

Another name for Area chart i think. Google images are showing me charts similar to that of area chart

 

[Fluff]

@Nitya0808
In future please limit the amount of data you post & do not select "All formulas" especially when there aren't any.
Thanks

 

[shg]

I've never used an area chart, so no suggestion.

 

[Nitya0808]

Apologies. Will take care.

@Nitya0808
In future please limit the amount of data you post & do not select "All formulas" especially when there aren't any.
Thanks

 

[Nitya0808]

Can you help me with the code to convert the table into the below Pivot table.

P01

P02

P03

P04

P05

P06

P07

P08

P09

P10

P11

P12

Unit 1

4.1

5.3

3.2

Unit 2

5.1

2.4

2

Unit 3

Unit 4

Unit 5

Unit 6

Unit 7

Unit 8

Unit 9

Unit 10

Unit 11

Unit 12

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[alansidman]

Cannot see any relationship between your first post and #7 . Please clarify. Your explanations are clearly elusive.

 

[Nitya0808]

Hi,

My first request still holds good. But since the other user mentioned he doesnt know shale, i requested if he can help me process the data to the mentioned format in #7 , as shale chart can be created with that format.

Thanks

 

[alansidman]

Still don't see any relationship that will lead to expected results. Suggest you show a before and after scenario using the same data set otherwise, we are throwing darts while blindfolded after being spun around a couple of times.