Modelo gráfico waterfall

Prévia do material em texto

Sales
													Label	Pillar
Vertex42: Pillars:
Place a letter "x" in this column to display the Flow value as a full-length bar or column. Except for the Start column, the Delta for a pillar should be zero (0).	EBIT
Vertex42: Delta:
Enter the positive and negative adjustments in this column, or zero (0) for a pillar.	Flow
Vertex42: Flow:
This column is labled "Flow" because in many waterfall charts, this would represent "Cash Flow."	
Vertex42: Pillars:
Place a letter "x" in this column to display the Flow value as a full-length bar or column. Except for the Start column, the Delta for a pillar should be zero (0).			Pillars	Base+	Base-	Delta+	Delta-	Invisible	Lines
													Budget	x	17,500	17,500	17,500	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	17,500
													january		- 284	17,216	ERROR:#N/A	ERROR:#N/A	17,216	ERROR:#N/A	284	17,500	17,216
													February		- 255	16,961	ERROR:#N/A	ERROR:#N/A	16,961	ERROR:#N/A	255	17,216	16,961
													March		13	16,974	ERROR:#N/A	16,974	ERROR:#N/A	13	ERROR:#N/A	16,974	16,974
													April		- 935	16,040	ERROR:#N/A	ERROR:#N/A	16,040	ERROR:#N/A	935	16,974	16,040
													May		198	16,237	ERROR:#N/A	16,237	ERROR:#N/A	198	ERROR:#N/A	16,237	16,237
													Jun		- 369	15,868	ERROR:#N/A	ERROR:#N/A	15,868	ERROR:#N/A	369	16,237	15,868
													July		- 4,832	11,036	ERROR:#N/A	ERROR:#N/A	11,036	ERROR:#N/A	4,832	15,868	11,036
													August		726	11,763	ERROR:#N/A	11,763	ERROR:#N/A	726	ERROR:#N/A	11,763	11,763
													September		453	12,215	ERROR:#N/A	12,215	ERROR:#N/A	453	ERROR:#N/A	12,215	12,215
													October		1,625	13,841	ERROR:#N/A	13,841	ERROR:#N/A	1,625	ERROR:#N/A	13,841	13,841
													November		2,043	15,884	ERROR:#N/A	15,884	ERROR:#N/A	2,043	ERROR:#N/A	15,884	15,884
													December		893	16,777	ERROR:#N/A	16,777	ERROR:#N/A	893	ERROR:#N/A	16,777	16,777
													Forecast	x		16,777	16,777	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	16,777
&"Arial,Regular"&8&K01+049https://www.vertex42.com/ExcelTemplates/waterfall-chart.html		&"Arial,Regular"&8&K01+049Waterfall Chart Template by Vertex42.com
Pillars	
Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	17500	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	16776.980563952995	Invisible	
Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	17500	17216.197209999998	16974.473579999998	16974.473579999998	16237.146349999999	16237.146349999999	15868.171966666665	11762.641040666664	12215.15649733333	13840.63597733333	15883.60748146633	16776.980563952995	#N/A	Delta+	#N/A	#N/A	#N/A	13.474330000000066	#N/A	197.52682999999979	#N/A	#N/A	726.16374400000018	452.51545666666675	1625.4794799999995	2042.9715041330001	893.37308248666682	#N/A	Delta-	#N/A	283.80279000000002	255.19795999999997	#N/A	934.85406	#N/A	368.97438333333326	4831.6946699999999	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	Base+	0	#N/A	#N/A	#N/A	13.474330000000066	#N/A	197.52682999999979	#N/A	#N/A	726.16374400000018	452.51545666666675	1625.4794799999995	2042.9715041330001	893.37308248666682	#N/A	Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	#N/A	#N/A	16974.473579999998	#N/A	16237.146349999999	#N/A	#N/A	11762.641040666664	12215.15649733333	13840.63597733333	15883.607481466328	16776.980563952995	#N/A	Base-	#N/A	283.80279000000002	255.19795999999997	#N/A	934.85406	#N/A	368.97438333333326	4831.6946699999999	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	0	Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	17216.197209999998	16960.999249999997	#N/A	16039.619519999998	#N/A	15868.171966666665	11036.477296666664	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	Flow	17500	17216.197209999998	16960.999249999997	169	74.473579999998	16039.619519999998	16237.146349999999	15868.171966666665	11036.477296666664	11762.641040666664	12215.15649733333	13840.63597733333	15883.60748146633	16776.980563952995	16776.980563952995	Lines	17500	17216.197209999998	16960.999249999997	16974.473579999	998	16039.619519999998	16237.146349999999	15868.171966666665	11036.477296666664	11762.641040666664	12215.15649733333	13840.63597733333	15883.60748146633	16776.980563952995	16776.980563952995	
EBIT
													Label	Pillar
Vertex42: Pillars:
Place a letter "x" in this column to display the Flow value as a full-length bar or column. Except for the Start column, the Delta for a pillar should be zero (0).	EBIT
Vertex42: Delta:
Enter the positive and negative adjustments in this column, or zero (0) for a pillar.	Flow
Vertex42: Flow:
This column is labled "Flow" because in many waterfall charts, this would represent "Cash Flow."	
Vertex42: Pillars:
Place a letter "x" in this column to display the Flow value as a full-length bar or column. Except for the Start column, the Delta for a pillar should be zero (0).			Pillars	Base+	Base-	Delta+	Delta-	Invisible	Lines
													Budget	x	2,493	2,493	2,493	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	2,493
													january		45	2,538	ERROR:#N/A	2,538	ERROR:#N/A	45	ERROR:#N/A	2,538	2,538
													February		- 148	2,390	ERROR:#N/A	ERROR:#N/A	2,390	ERROR:#N/A	148	2,538	2,390
													March		61	2,450	ERROR:#N/A	2,450	ERROR:#N/A	61	ERROR:#N/A	2,450	2,450
													April		- 48	2,403	ERROR:#N/A	ERROR:#N/A	2,403	ERROR:#N/A	48	2,450	2,403
													May		173	2,576	ERROR:#N/A	2,576	ERROR:#N/A	173	ERROR:#N/A	2,576	2,576
													Jun		- 30	2,546	ERROR:#N/A	ERROR:#N/A	2,546	ERROR:#N/A	30	2,576	2,546
													July		- 2,018	528	ERROR:#N/A	ERROR:#N/A	528	ERROR:#N/A	2,018	2,546	528
													August		456	984	ERROR:#N/A	984	ERROR:#N/A	456	ERROR:#N/A	984	984
													September		79	1,062	ERROR:#N/A	1,062	ERROR:#N/A	79	ERROR:#N/A	1,062	1,062
													October		758	1,820	ERROR:#N/A	1,820	ERROR:#N/A	758	ERROR:#N/A	1,820	1,820
													November		- 141	1,680	ERROR:#N/A	ERROR:#N/A	1,680	ERROR:#N/A	141	1,820	1,680
													December		601	2,281	ERROR:#N/A	2,281	ERROR:#N/A	601	ERROR:#N/A	2,281	2,281
													Forecast	x		2,281	2,281	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	2,281
&"Arial,Regular"&8&K01+049https://www.vertex42.com/ExcelTemplates/waterfall-chart.html		&"Arial,Regular"&8&K01+049Waterfall Chart Template by Vertex42.com
Pillars	
Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	2493	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	2280.7854611371786	Invisible	
Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	2537.6183099999998	2537.6183099999998	2450.4490441999997	2450.4490441999997	2575.7142841999994	2575.7142841999994	2546.1527155333329	983.58672623333314	1062.4902920666666	1820.4669962666658	1820.4669962666658	2280.7854611371786	#N/A	Delta+	#N/A	44.618310000000008	#N/A	60.811544200000043	#N/A	172.8784099999998	#N/A	#N/A	455.77174070000001	78.90356583333346	757.9767041	9999918	#N/A	601.13658371133351	#N/A	Delta-	#N/A	#N/A	147.98080999999991	#N/A	47.613170000000025	#N/A	29.561568666666631	2018.3377299999997	#N/A	#N/A	#N/A	140.81811884082072	#N/A	#N/A	Base+	0	#N/A	44.618310000000008	#N/A	60.811544200000043	#N/A	172.8784099999998	#N/A	#N/A	455.77174070000001	78.90356583333346	757.97670419999918	#N/A	601.13658371133351	#N/A	Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	2537.6183099999998	#N/A	2450.4490441999997	#N/A	2575.7142841999994	#N/A	#N/A	983.58672623333314	1062.4902920666666	1820.466996266666	#N/A	2280.7854611371786	#N/A	Base-	#N/A	#N/A	147.98080999999991	#N/A	47.613170000000025	#N/A	29.561568666666631	2018.3377299999997	#N/A	#N/A	#N/A	140.81811884082072	#N/A	#N/A	0	Budget	january	February	March	April	May	Jun	July	August	September	October	November	December	Forecast	#N/A	#N/A	2389.6374999999998	#N/A	2402.8358741999996	#N/A	2546.1527155333329527.81498553333313	#N/A	#N/A	#N/A	1679.6488774258451	#N/A	#N/A	Flow	2493	2537.6183099999998	2389.6374999999998	2450.4490441999997	2402.8358741999996	2575.7142841999994	2546.1527155333329	527.81498553333313	983.58672623333314	1062.4902920666666	1820.4669962666658	1679.6488774258451	2280.7854611371786	2280.7854611371786	Lines	2493	2537.6183099999998	2389.6374999999998	2450.4490441999997	2402.8358741999996	2575.7142841999994	2546.1527155333329	527.81498553333313	983.58672623333314	1062.4902920666666	1820.4669962666658	1679.6488774258451	2280.7854611371786	2280.7854611371786