Pivot Chart Customizing lost on Refresh
 

Any change of chart type or axis for a series within a pivot chart is lost
when I refresh my pivot data.
-Can I prevent this with with options or coding.?
-Or shall I run code to redo the changes after each update?
--
Nita J. Perez