Waterfall charts in a Combo Chart / Automatically Adding a line at 0 to highlight

Hi,

I have a file with multiple automations that allows me to create as much projects as I want (between 40-50).

I just found out that Excel had "Waterfall" charts and my problem is that I want to emphasize on the breakeven point by adding a line on 0 (like the red line on the image), but the Waterfall charts seems to be incompatible with "Combo Charts" in Excel (therefore, the line with all the "0" remains unused).

Is there a way to do this ? To automate this ? I know my way around VBA relatively well, so a macro could be a good solution.

Thanks !!


P.S. Each project are based on the "reference project" sheet, therefore, if I get it right on this sheet, it would work on any of my 40-50 projects ...

(Unless someone has a better answer ...)

I will be answering my own post :

Waterfall charts are very picky :
~~~~~~~~~~~~~~~~~~~~~
- They do not accept any value linking to other cells in the workbook (eg. Title, Axis name, etc.)
- They do not accept "Combo Charts" which is what I need.
- With a big project, they can create an Excel meltdown where the calculation time is multiplied by 30, 50 or even 100 times what it should be (in rare cases where I have not observed any pattern, but going from 20 seconds to 15 minutes for the same task is not normal ... and with a restart of Excel or a Reboot, everything is going fine ...)

Logically speaking, stay away from these charts if you can