Pivot Chart Colours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 13 Apr 2007 14:20 GMT

Whenever I change the colours in a pivot chart and then add/amend/refresh
the pivot data the colours revert back to the original defaults.

Is there any way to prevent this so I can retain my selected colours?

Many thanks,

Jason

Reply to this Message

Debra Dalgleish - 13 Apr 2007 18:56 GMT

This is a known problem with pivot charts. There's information in the
following MSKB article, which suggests using a macro to reapply the
formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904

> Whenever I change the colours in a pivot chart and then add/amend/refresh
> the pivot data the colours revert back to the original defaults.
>
> Is there any way to prevent this so I can retain my selected colours?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Jay - 14 Apr 2007 13:42 GMT

Many thanks Debra,

I kinda thought it must be an inbuilt limitation of XL. I'm using 2003,
is 2007 the same?

Jason

> This is a known problem with pivot charts. There's information in the
> following MSKB article, which suggests using a macro to reapply the
[quoted text clipped - 8 lines]
>>
>> Is there any way to prevent this so I can retain my selected colours?

Reply to this Message

Debra Dalgleish - 14 Apr 2007 14:06 GMT

In Excel 2007 you can refresh the pivot table, and the formatting
changes stay in the pivot chart. There's a bit more information in this
Excel blog:

http://blogs.msdn.com/excel/archive/2006/04/19/579649.aspx

> Many thanks Debra,
>
[quoted text clipped - 15 lines]
>>>
>>> Is there any way to prevent this so I can retain my selected colours?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: