View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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