Pivot Chart changes chart upon refresh

[chris46521]

I have created a pivot table and chart. The pivot chart consists o
three sets of data from the pivot table. Two of the data sets are line
and the third data set is displayed as columns. I made the third dat
set into columns by right clicking on the data series line an
selecting chart type. I change the chart type for that data set to
column and it worked great. The only problem is that when data i
refreshed in the associated pivot table, the entire chart turns int
columns with completely different formatting. Does anyone know how
can maintain the graph with the two lines and one column data set whe
I refresh the data? Thanks for your help

 

[Jon Peltier]

This has been a known issue with pivot charts since their introduction.
Here's Microsoft's suggestion:

http://support.microsoft.com/?id=215904

They suggest recording a macro the next time you have to reformat the pivot
hart, then replay it every time after that.

- Jon