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