How do I set permanent secondary axis in PivotTable chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
hi, Jon Peltier :
Do you have some samples for dealing with this issue. macro or otherss
thanks.

“Jon Peltierâ€ç¼–写：
 
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/
_______
 
Back
Top