Hi,

Have a read of this,
http://peltiertech.com/Excel/Pivots/pivotcharts.htm

The loss of formatting is a know bug. requires VBA work around.

Cheers
Andy

Souris wrote:
The pivot chart data label always disappear when pivot table refresh.

Are there any way to automation that to have data label automation shows and
to the right location on the chart sheet?

Your information is great appreciated,

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info