Re: Retaining formatting of a chart produced from a pivot table

In his Charting FAQ, Jon Peltier says that Microsoft suggests using a 
macro to reapply the formatting:

    http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon026

John wrote:
> I create a piviot table from my data, then produce a chart.  I
> re-order the columns (they are already moved around by Excel so do not
> appear in the order they are recorded in the baseline data).  If I
> change the chart by manipulating pivot table options my formatting is
> lost - i.e. the chart reverts to the formatting Excel has already
> imposed.  Any ideas how to stop this?

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