software

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) .
support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
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(quot;TransactionChartquot;), Name:=quot;Standard Chart Formatquot;

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

Thanks

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Known bug: See MSKB article, XL2000: Changing a PivotChart Removes
gt; Series Formatting (Q215904) .
gt; support.microsoft.com/default...;EN-US;Q215904
gt;
gt; Cheers
gt; Andy
gt;
gt; larry garka wrote:
gt; gt; After setting custom pivotchart patterns the patterns are reset to default
gt; gt; after underlying pivottable is refreshed. How can we make the custom
gt; gt; patterns remain in place after pivottable refresh?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

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
www.andypope.info
quot;steven nquot; lt;steven gt; wrote in message
...
gt; Andy, I am having same issues. I am not well versed in Visual Basic so am
gt; having trouble creating this AutoFormat macro.
gt;
gt; This is what I inputted into VB to run an AutoFormat macro:
gt;
gt; Application.AddChartAutoFormat _
gt; Chart:=Charts(quot;TransactionChartquot;), Name:=quot;Standard Chart Formatquot;
gt;
gt; Is this correct? If so, how do I run it?
gt;
gt; Thanks
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; Known bug: See MSKB article, XL2000: Changing a PivotChart Removes
gt;gt; Series Formatting (Q215904) .
gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt;gt;
gt;gt; Cheers
gt;gt; Andy
gt;gt;
gt;gt; larry garka wrote:
gt;gt; gt; After setting custom pivotchart patterns the patterns are reset to
gt;gt; gt; default
gt;gt; gt; after underlying pivottable is refreshed. How can we make the custom
gt;gt; gt; patterns remain in place after pivottable refresh?
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Andy Pope, Microsoft MVP - Excel
gt;gt; www.andypope.info
gt;gt;