Hi,

Have a read of the following page, which includes details on Pivot charts
losing formatting.
http://peltiertech.com/Excel/Pivots/pivotcharts.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Daniel" wrote in message
...
My problem is when I hit "refresh data" my chart color, series type
changed to
default which I don't like.
How to change default chart color, chart type, line.....
Thnks
Daniel