Pivot charts are a real bummer with formatting. Any change to the underlying
table resets the formatting. Microsoft admits that it's a problem, and the
problem persists from Excel 2000 through 2003:
Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"lay" wrote in message
...
I saw a similar question that asked about applying conditional formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.
Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?
Thanks!