Aligning zeros on both y axis

Hi,

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!

Cheers,

sample.jpg 

 

 

Tagged:

Best Answer

  • Valiant
    Valiant 🔵
    Accepted Answer

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

    image.png

     

    It sound like that may get you what you need.

     

    Sincerely,
    Valiant

     

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

Answers

This discussion has been closed.