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.

[TABLE="width: 512"]
<tbody>[TR]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: red"]-20
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: red"]-20
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: #C4D79B"]+10
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

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