Formating a Pivoting Chart

I have a pivoting line graph. If I change the colors of
the lines, they change back to the default every time I
pivot. Does anyone know how to perserve the formats when
I pivot to new data???

Thanks
Jon

Loss of formatting 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:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904


Jon wrote:
> I have a pivoting line graph. If I change the colors of
> the lines, they change back to the default every time I
> pivot. Does anyone know how to perserve the formats when
> I pivot to new data???
>
> Thanks
> Jon


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html