Combo chart with negative values - '0' position between primary and secondary axis
I am using a combo chart to show:
- Monthly revenue on the primary axis (left end side). Values can be positive or negative.
- Cumulative revenue on the secondary axis (right end side).
Showing the negative values from the primary axis impacts the secondary axis (the '0' on the secondary axis starts at the same position than the '-10' on the primary axis). I am able to get the 0s on the same position only by clicking on Auto range in appearance; however, the negative values form my monthly revenues then disappear from the visual.
I also tried RangeMin() and RangeMax() formulas to define my Min and Max - not working.
Does anyone know how I could show negative values - on the primary axis - while having the '0' from both axis in the same position?