This is a known "feature" of pivot charts. See the second item under
"Troubleshooting" on this page:
http://peltiertech.com/Excel/Pivots/pivotcharts.htm
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Cam" wrote in message
...
Hello,
I have a chart that came from the pivot table. It is a custom chart "2
lines
with 2 axis". I formatted everything to way I want to look. But then
everytime the data (pivot table) is refreshed (updated) the chart went
back
to the initial default format.
How can I make it so it always stay with the format I created? Thanks