Chart Primary & Secondary Axis Issue

[JC3]

Hi

I have three figures to display in a chart.

The Total Ongoing Calls
The Ongoing Calls in Area 1
The Ongoing Calls in Area 2

Ideally the Total Ongoing Calls should equal the other two but this is never the case due to calls in wrongs areas etc. To display this I have the Total Ongoing Calls shown as an Area Chart on the Primary Axis with the other two figures shown as a Stacked Area Chart on the Secondary Axis.

This way if I manually fix the Primary and Secondary Axis Scale to the same then I can see at a glance the total in both areas and the discrepancy from the Total. Great.

The issue is that the Primary Axis will almost always be slightly higher than the Secondary Axis which means that whenever the Scale changes I would have to manually change the other Axis. Is there any way, programaticallly or otherwise, that I can link the two Axis together so that if one changes up or down the other changes with it.

Thanking everyone I am about to confuse in advance.

JC

 

[JC3]

After given further thought to this I came up with the exceedingly simple solution.

Simply take the Total Calls subtract the Calls in Area 1 & Area 2 and add this to the chart as Other Calls. Then all three fields can be plotted on the Primary axis thus avoiding the issue.

Its funny how once you stop working on something the answer comes back to you.

Oh well.

Thanks anyway.