Aligning zeros on both y axis


I'm wondering if there is a way to align both y axis (primary and secondary) on a combined bar and line or symbol graph, so the zero line (x axis) intercepts both at the same time.

In other words, how can the zero in the primary y axis be right in front of the secondary y axis?

As a workaround, I can manually set the limits for both Y axis, to force them to coincide, but this requires me updating the scale if at some point any of the values escapes the pre-detemine ranges.

I hope the question is clear.... please see below how it currently looks.


Any assistance would be greatly appreciated.

Thank you!






Best Answer

  • Valiant
    Valiant 🔵
    Answer ✓

    In the chart properties under General. There is an option for 'Sync 0 Lines'. (You can also Sync Value Scales if you want)



    It sound like that may get you what you need.




    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.


This discussion has been closed.