How to create a water fall chart?

[isolarworkx]

Dear all,
Can you please let me know how to create a water fall chart in libreoffice?
Thanks,
Ali

[mariosv]

An excel template, that seems work fine with LibreOffice

Water fall chart template

[ROSt53]

@mariosv - I developed a while ago my own template for water fall charts in Calc. Work fine. However. I like to add horizontal lines between to column elements. Is there a way in Calc do do this?

[mariosv]

Hi @ROSt53, there is an option in Formatting Series, but it works between the same serie’s data, so I guess it depends on how chart is organized. Or maybe and stock column with line, generating a serie for the line with other data series.

[ROSt53]

@mariosv thanks for the hint I will try it next time.