I am new to charting. I was able to kill two birds with stone for my manager. I created a pivot along with an attached pivot chart. It worked great. Then he wanted the values on each bar rotated 90 degrees and placed at the end of the each bar. I figured that out too! Then he wanted the bar colors changed. Did that one too. The only problem is that when he refreshes the pivot, the chart looses the formatting changed I made...Boooooo!

How can I preserve my formatting changes on the pivot chart?