Changing secondary axes with VBA

[Jacobs]

I found the following code to change the scale of the primary x and y axes of a chart by changing cells in a worksheet. The existing chart has a secondary axis that I would like to be able to also change by changing a cell value as well. When I copied the code and modified it so that the AxisGroup specified the seconadry axis, the code doesn't work. The code is in the worksheet module page and not a stand alone module. I can not figure out what is going on. Any help will be very appreciated. I will be glad to provide more detail is needed. Here is the code:

Please Login or Register  to view this content.

[Jacobs]

I figured it out. Thanks.