Aligning zeros on both y axis

Gonz

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,

 

 

 

Valiant

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.

 

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.

Valiant

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.

 

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.

Gonz

Hi Valiant

 

Perfect thanks heaps!

 

Cheers

Gonz