software

Hello: I'm stumped!

I have some charts whose source data comes from pivot tables. I have
customized the formatting. Everytime I refresh the pivot data, I lose the
chart formatting and it reverts to the default.

Is there anyway of preventing this while keeping the pivot tables quot;live?quot;

thanks

This is a known problem with pivot charts. There's information in the
following MSKB article, which suggests recording a macro as you apply
the formatting:

Changing a PivotChart removes series formatting in Excel
support.microsoft.com/?id=215904Stilla wrote:
gt; Hello: I'm stumped!
gt;
gt; I have some charts whose source data comes from pivot tables. I have
gt; customized the formatting. Everytime I refresh the pivot data, I lose the
gt; chart formatting and it reverts to the default.
gt;
gt; Is there anyway of preventing this while keeping the pivot tables quot;live?quot;
gt;
gt; thanks--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlAHHHHHHH I see. Thank you for clearing up a mystery.

quot;Debra Dalgleishquot; wrote:

gt; This is a known problem with pivot charts. There's information in the
gt; following MSKB article, which suggests recording a macro as you apply
gt; the formatting:
gt;
gt; Changing a PivotChart removes series formatting in Excel
gt; support.microsoft.com/?id=215904
gt;
gt;
gt; Stilla wrote:
gt; gt; Hello: I'm stumped!
gt; gt;
gt; gt; I have some charts whose source data comes from pivot tables. I have
gt; gt; customized the formatting. Everytime I refresh the pivot data, I lose the
gt; gt; chart formatting and it reverts to the default.
gt; gt;
gt; gt; Is there anyway of preventing this while keeping the pivot tables quot;live?quot;
gt; gt;
gt; gt; thanks
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;