How do I set permanent secondary axis in PivotTable chart?

[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.

 

[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/
_______

 

[Guest]

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

“Jon Peltierâ€ç¼–写：

 

[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/
_______