Pivot Tables & Charts

Hello,

When I refresh the data in my pivot tables all the charts associated with that table revert back to the standard formating for that style chart. I would like to set the formating on a Pivot chart and have it locked in and still be able to refresh the data.

Thanks in advanced for any help

Steve

Thanks

Steve