Changing axes X and Y in a plot in VBA

[renatoab]

I'd like to change the axis X and Y (change to the inverse function).

The easiest way I thought is manipulating the ActiveChart.SeriesCollection properties
- get the formula of the series and change the string into them
- manipulate it changing X and Y values

but I don't know exactly how to do.

Because I have 4 properties: Formula, FormulaLocal, FormulaR1C1, FormulaR1C1Local.

Do I have to change both of them? It's not working.

I'd like to do this way, because the Sub I'm using to generate the charts gets the entire range with x and y values, and I want to change after that Sub, when it's everithing done.

Do I have any other option?

Thank you

 

[renatoab]

I found an error, and it worked only changing the "formula".

 

[Jon Peltier]

Google would have helped you find an existing utility:

Switch X and Y on an XY Chart