|
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 |
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. |
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. |
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. |
| All times are GMT +1. The time now is 07:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com