+ Reply to Thread
Results 1 to 3 of 3

Change primary and secondary axes in pivot chart through VBA

  1. #1
    Registered User
    Join Date
    10-03-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    6

    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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,828

    Re: Change primary and secondary axes in pivot chart through VBA

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-03-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Change primary and secondary axes in pivot chart through VBA

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Format primary and secondary axes with VBA
    By KATIEexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 08:28 AM
  2. Format primary and secondary axes with VBA
    By KATIEexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 06:33 AM
  3. Replies: 1
    Last Post: 03-13-2012, 10:51 AM
  4. Matching the min & max values for Primary and Secondary axes
    By Neil in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-08-2006, 02:10 PM
  5. Lining up scales on primary and secondary y axes
    By MarkN in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-08-2006, 08:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1