Change primary and secondary axes in pivot chart through VBA

Hi everyone,

I believe this is probably a pretty simple question, but I can't seem to find the answer online. I'm trying to change the minimum and maximum values of the primary and secondary fields of a pivot chart through vba code. The code below doesn't result in any errors, but it doesn't alter the pivot chart as far as I can tell. Any help on this is greaty appreciated!

Please Login or Register  to view this content.

Thanks!
Jen

Thank you Ryan! I'll never forget to reference the pivot chart instead of the pivot table again!