waterflow chart with calculation

[IF]

Hi,

I want to make a very difficult waterfall chart from the following table:

Name	Type1	Type2	Type3	S	C	D	A	TBD
a1	A	#	P	1			1
a2	B	#	P	1			1
a3	C	#	B	1			1
a4	#	Y	N	1	1		1
a5	#	Y	N	1	1		1
a6	A	#	N	1			1
a7	#	Y	N	1	1		1
a8	B	#	P	1			1
a9	A	#	P	1			1
a10	A	#	N	1			1
a11	#	Y	O		1	1
a12	#	#	O			1
a13	#	Y	N	1	1		1
a14	B	#	P	1			1
a15	#	Y	O		1	1
a16	A	#	P	1			1	1
a17	A	#	P	1			1	1
a18	#	Y	N	1	1		1
a19	B	#	P	1			1
a20	C	#	N			1

I consider the count of each row and the result is:

	S	C	D	A	TBD
Count	16	7	4	16	2

And I want to make the following chart:

The waterfall chart has 8 steps. It starts and ends with S column. Green is  count of C column, red is shown as decrease. Purpol (A column) doesn't have any relationship with the previous ones. It is just reflection of count of column A.  Second red column is TBD column and it is decrease. Blue column is a calculation column, based on A-TBD result, which is X. Yellow (Y value) is X-S. At the end S column is repeated.

I hope I can find a solution for this.

All the best

[lbendlin]

I think you are talking about two separate waterfall charts.