Make pivotchart formatting stick after pivottable refresh.

[Guest]

After setting custom pivotchart patterns the patterns are reset to default
after underlying pivottable is refreshed. How can we make the custom
patterns remain in place after pivottable refresh?

 

[Andy Pope]

Hi,

Known bug: See MSKB article, XL2000: Changing a PivotChart Removes
Series Formatting (Q215904) .
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904

Cheers
Andy

 

[steven n]

Andy, I am having same issues. I am not well versed in Visual Basic so am
having trouble creating this AutoFormat macro.

This is what I inputted into VB to run an AutoFormat macro:

Application.AddChartAutoFormat _
Chart:=Charts("TransactionChart"), Name:="Standard Chart Format"

Is this correct? If so, how do I run it?

Thanks

 

[Andy Pope]

Hi,

You need to record the code of you changing the column fill colour for
instance.
I think what you have is too high a level. And if it did work is Standard
formatting not what the pivot chart reverts to.

This macro will set the colour of the bars to red.

Sub Macro3()
'
' Apply red formatting to columns

With ActiveChart.SeriesCollection(1)
.Interior.ColorIndex = 3
End With

End Sub

Cheers
Andy