Format of chart changes everytime refresh data, why?
 

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

Format of chart changes everytime refresh data, why?
 

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