Skip to Content
0
Former Member
Feb 25, 2011 at 02:01 PM

Combination Chart: How to link auto-scaling of both Y-Axis?

33 Views

I have a combination chart showing a couple bars and a couple lines. The bars use the left Y-Axis and the lines correspond to the right Y-Axis. Although they are based off seperate Y-Axis', the information is still related to each other.

Under my combination chart i have a slider which increases/decreases a 3rd set of red bars and it can push them so high that the Y-Axis will auto-scale itself, which is great. But what happens is the secondary Y-Axis will not also re-scale to go wth the primary Y-Axis. I have 2 screenshots to help demonstrate things a bit better. So although the information is still technically correct, it is visibly incorrect. Is there a way to link these 2 Axis together so it knows the max on the left Y-Axis before touching the slider is related to the max on the right Y-Axis? So if the primary y-axis grows, the secondary needs to as well?

PICTURES

The slider adjusts the red bars and i put them all the way up just before the point where it re-scales the primary y-axis:

http://img38.imageshack.us/img38/7853/beforel.jpg

Now i cranked the slider all the way up and the primary y-axis rescaled itself but the bars still look the exact same in relation to that blue line running across them. The 2 lines on the graph that use the right y-axis should have dropped lower at the same time the blue/yellow bars did:

http://img602.imageshack.us/img602/7996/afters.jpg

Thanks for the help, I appreciate it!