cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

DebjitSingha
Active Contributor
0 Kudos

Hi Scott,

You can control the scaling on the secondary Y axis. Find the maximum of the data for line as well as the column chart (here you can take help of MAX() excel formula) then take the maximum value out of the result and that cell storing data from slider. In this way we can find out the largest data among all. Use that data as the maximum limit for primary as well as for secondary axis,

Go to the Behavior tab of the chart > primary scale > maximum limit > elect the cell containing the calculated maximum value.

Repeat the same steps for secondary axis also. Now the change in one series will have uniform effect on both the axis.

Answers (0)