Limits of Pivot chart

[Guest]

I created dynamic pivot chart based on Pivot table. But I don't like this
chart much since it change to default when I "refresh data". My question

How can I create a normal dynamic chart based on a pivot table which will
not change to default when I hit refresh data?

Thanks for your help.
Daniel

 

[Andy Pope]

Hi,

See here for more information on the bug regarding pivot chart formating
and how to work with and around them.

http://peltiertech.com/Excel/Pivots/pivotcharts.htm

Cheers
Andy