Limits of Pivot chart
 

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

Limits of Pivot chart
 

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

Daniel wrote:
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