Hi,

I have below data with me, i need to create a water fall chart. Currently i am doing it manually. I am looking for any automated tool that would create the water fall chart by taking data from two pivot table. And if the below options are possible

1. Create slicers from both the pivots and link them together to get the required waterfall chart. And it would include all the data so that from the slicers if i have only to select the required options and it show the waterfall chart like... chart for count (total and Market wise), value (Total and Market wise).
2. Can I show the total value of closing balance as a line chart in the water fall as secondary axis. (value of the blue bars in the example)
3. How to add/show week 1, week 2 ....below the water fall chart (between opening and closing balance)

Excel File - http://1drv.ms/1yhZaNN

Total value is Opening and closing balance

Pivot 1 for Opening and Closing Data

Pivot 2 for Input data

Input Data

Total

DE

Hi,

I have below data with me, i need to create a water fall chart. Currently i am doing it manually. I am looking for any automated tool that would create the water fall chart by taking data from two pivot table. And if the below options are possible

1. Create slicers from both the pivots and link them together to get the required waterfall chart. And it would include all the data so that from the slicers if i have only to select the required options and it show the waterfall chart like... chart for count (total and Market wise), value (Total and Market wise).
2. Can I show the total value of closing balance as a line chart in the water fall as secondary axis. (value of the blue bars in the example)
3. How to add/show week 1, week 2 ....below the water fall chart (between opening and closing balance)

I can't insert image...it can be found in the below link

http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/water-fall-chart-by-linking-two-pivot-table/3f10e5ac-9f8b-4c15-bd5e-251183f2ad32#LastReply

Excel File with data in the one drive location- http://1drv.ms/1yhZaNN

Total value is Opening and closing balance

Pivot 1 for Opening and Closing Data

	W1		W2		W3
Row	Count	Value	Count	Value	Count	Value
DE	197	7.81	198	6.92	213	8.39
ES	23	0.39	26	0.43	23	0.34
FR	210	3.57	224	3.65	229	3.80
IT	29	0.27	36	0.35	37	0.24
UK	211	4.52	230	5.29	193	4.82
Total	670	16.56	714	16.64	695	17.60

Pivot 2 for Input data

Row	W1	W2	W3
DE	12	41	39
ES	2	3	4
FR	14	43	42
IT	3	3	10
UK	18	42	34
Total	49	132	129

Input Data

	Week1	Week2	Week3
Opening	686 (from Prev Month)	670	714
Input	49	132	129
Process	65 (opening+input-Closing)	88	148
Closing	670	714	695
Value	16.56	16.64	17.60

Total

Open	686			670			714			695
Base		686	670		670	714		714	695
Input		49			132			129
Process			65			88			148

DE

Open	212			197			198			213
Base		212	197		197	198		198	213
Input		12			41			39
Process			27			40			24