Toggling Secondary & Primary Axises

Hi all.

I am working on a chart that displays a series collection on the 2nd axis if it is present, the code:

Please Login or Register  to view this content.

This worked great the first time but now all values are coming up on the 2nd axis even when the name "Composite Escalation Rate" is not present. I have a procedure dedicated to chart display but I am lost in it but here it is

Please Login or Register  to view this content.

The following code was an attempt to solve the problem but it did nothing

Please Login or Register  to view this content.

I can upload the workbook but if someone has an idea of what I am trying to accomplish through the code I have provided I would really appreciate it. I only want the one series collection to display on the right side or 2nd axis if it is present, otherwise, display everything else on the left. Any ideas?

Because my file is quite large, I'm going to supply a picture (knowing how you all love pictures ).The right side Y-Axis should be on the left side and the left side Y-Axis should be on the right if and only if the Composite Escalation Rate is a part of the chart, otherwise the right Y-Axis should not be there. This has been a struggle for me and the books that I have don't go into VBA and charting with too much detail.Axis.JPG

Try using the AxisGroup setting

Please Login or Register  to view this content.