Chart type & how to make

[fangfacekitty]

Hi,
Can someone tell me what kind of chart or graph this is & how to make on in excel? I call it a step chart because it is supposed to show the series of steps taken to result in the final value - kind of like the credits & debits in your checkbook that result in your bank balance. The picture refuses to copy correctly - the -20 should be twice as tall as they are and the +10 is not supposed to be underneath the -20, it should be next to it.

				+10
			+10		-20
		+10			+10
	+10						-20
+10

<tbody>
</tbody>

Thanks in advance.

 

[thisoldman]

I think you want a waterfall or bridge chart.

Waterfall charts are available as a built-in type in Excel 2016:

https://support.office.com/en-us/ar...ice-2016-8de1ece4-ff21-4d37-acd7-546f5527f185

To create them in earlier versions of Excel, try these tutorials:

http://peltiertech.com/excel-waterfall-charts-bridge-charts/

http://www.contextures.com/excelwaterfallchart.html

 

[fangfacekitty]

Great, this is exactly what I was looking for. Thanks!.

I think you want a waterfall or bridge chart.

Waterfall charts are available as a built-in type in Excel 2016:

https://support.office.com/en-us/ar...ice-2016-8de1ece4-ff21-4d37-acd7-546f5527f185

To create them in earlier versions of Excel, try these tutorials:

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog
http://www.contextures.com/excelwaterfallchart.html