Make waterfall with target

[luisalbertojb]

Hello people

I will like make a waterfall graph with a additional column in the end for compared with my result. I attach an image. Thanks for any help.

[KerKol]

The stacked combo bar and line chart might help you in this instance. 

You could create a waterfall chart by stacking coloured bars on top of white bars to create this kind of effect:

Then you could create an extra total at the end.

[KerKol]

Which I just added for demo