Pivot / general chart formatting question
 

Hi

I'm writing some code to preserve the formatting of a couple of pivot charts
(one stacked bar and one pie) using Excel XP.

I found reference to the fact formatting is reset when the pivot is
recalculated etc.
(http://support.microsoft.com/default...;EN-US;Q215904), not a
very usefull article by the way. Just tells us to write some code. Anyway...

I am able to reference and format various series by name in the bar charts,
but in the pie chart, if I record a macro the fomatting is associated with a
point within the series.

I need to be able to reference the points by name, preferably without having
to refer to the data lable property as the user may opt to switch off the
data lables. Referencing them by index value is no good as the index may
change if filters are applied / removed form the pivot. Put simply, how can
I preserve formatting in a pie pivot chart when filters are applied or
removed? MS suggest recording and replaying a macro of the original
formatting but this doesn't work where filters are applied etc. as it used
indexes.

Anyone know if this is possible or is there a simpler / better way?

Thanks very much

Mark