+ Reply to Thread
Results 1 to 4 of 4

How do I set permanent secondary axis in PivotTable chart?

  1. #1
    Microlong
    Guest

    How do I set permanent secondary axis in PivotTable chart?

    Hi, I have problem about PivotTable chart. Now I have already set secondary
    axis in my PivotTable chart, they appear by line type.But the secondary axis
    will disappear when I drill down from some dimensions. for example, the first
    axis is A, the secondary is B. When I drill down from year to month, B will
    disappear. I have to reset B as secondary axis. Do you have some ways or
    options to set permanet secondary axis in PivotTable chart?
    thanks.
    --
    Developer
    QA Dashboard
    Microsoft China Development Centre

  2. #2
    Jon Peltier
    Guest

    Re: How do I set permanent secondary axis in PivotTable chart?

    Unfortunately, pivot tables and pivot charts lose their formatting when they are
    updated. Even MS admits this is an issue. You could record a macro while you
    reformat your chart, then rerun the macro after updating the pivot chart.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Microlong wrote:

    > Hi, I have problem about PivotTable chart. Now I have already set secondary
    > axis in my PivotTable chart, they appear by line type.But the secondary axis
    > will disappear when I drill down from some dimensions. for example, the first
    > axis is A, the secondary is B. When I drill down from year to month, B will
    > disappear. I have to reset B as secondary axis. Do you have some ways or
    > options to set permanet secondary axis in PivotTable chart?
    > thanks.



  3. #3
    Microlong
    Guest

    Re: How do I set permanent secondary axis in PivotTable chart?

    hi, Jon Peltier :
    Do you have some samples for dealing with this issue. macro or otherss
    thanks.

    “Jon Peltierâ€?ç¼–å*™ï¼š

    > Unfortunately, pivot tables and pivot charts lose their formatting when they are
    > updated. Even MS admits this is an issue. You could record a macro while you
    > reformat your chart, then rerun the macro after updating the pivot chart.
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    > Microlong wrote:
    >
    > > Hi, I have problem about PivotTable chart. Now I have already set secondary
    > > axis in my PivotTable chart, they appear by line type.But the secondary axis
    > > will disappear when I drill down from some dimensions. for example, the first
    > > axis is A, the secondary is B. When I drill down from year to month, B will
    > > disappear. I have to reset B as secondary axis. Do you have some ways or
    > > options to set permanet secondary axis in PivotTable chart?
    > > thanks.

    >
    >


  4. #4
    Jon Peltier
    Guest

    Re: How do I set permanent secondary axis in PivotTable chart?

    I don't have a generic macro for this, every situation is different. Recording a few
    macros like this, and figuring out how they work, is probably a good way to get started.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Microlong wrote:

    > hi, Jon Peltier :
    > Do you have some samples for dealing with this issue. macro or otherss
    > thanks.
    >
    > “Jon Peltierâ€?ç¼–å*™ï¼š
    >
    >
    >>Unfortunately, pivot tables and pivot charts lose their formatting when they are
    >>updated. Even MS admits this is an issue. You could record a macro while you
    >>reformat your chart, then rerun the macro after updating the pivot chart.
    >>
    >>- Jon
    >>-------
    >>Jon Peltier, Microsoft Excel MVP
    >>Peltier Technical Services
    >>Tutorials and Custom Solutions
    >>http://PeltierTech.com/
    >>_______
    >>
    >>Microlong wrote:
    >>
    >>
    >>>Hi, I have problem about PivotTable chart. Now I have already set secondary
    >>>axis in my PivotTable chart, they appear by line type.But the secondary axis
    >>>will disappear when I drill down from some dimensions. for example, the first
    >>>axis is A, the secondary is B. When I drill down from year to month, B will
    >>>disappear. I have to reset B as secondary axis. Do you have some ways or
    >>>options to set permanet secondary axis in PivotTable chart?
    >>>thanks.

    >>
    >>



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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