More PivotTable Trouble

[Brad]

Good morning..

I have a customized PivotChart with everything just the
way I like it. Specifically, the data labels on the
columns are vertical and font size is 8. When my user
changes the Page Field value, the font size jumps back up
to 12 and the alignment turns to horizontal again.

Autoscale isn't helping me, either. I can't find an event
to capture of the Worksheet/Workbook objects to change the
labels back.

Input please?

Thank you.

-Brad

 

[Mike Waldron]

Hi Brad

I've had similar problems with line colors on pivot charts
changing. This worked for me:
Private Sub chart_calculate()
Call StandardColors
End Sub
As you know the code goes in the chart sheet.

You probably need to track the change in the cell that
displays the page field.

Mike