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?

Hi,

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

Cheers
Andy

larry garka wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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" wrote:

Hi,

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

Cheers
Andy

larry garka wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"steven n" <steven wrote in message
...
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" wrote:

Hi,

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

Cheers
Andy

larry garka wrote:
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, Microsoft MVP - Excel
http://www.andypope.info