Make pivotchart formatting stick after pivottable refresh.

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

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, 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
 
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
 
Back
Top