Pivot Chart changes chart upon refresh

[chris46521]

I have created a pivot table and chart. The pivot chart consists of three sets of data from the pivot table. Two of the data sets are lines and the third data set is displayed as columns. I made the third data set into columns by right clicking on the data series line and selecting chart type. I change the chart type for that data set to a column and it worked great. The only problem is that when data is refreshed in the associated pivot table, the entire chart turns into columns with completely different formatting. Does anyone know how I can maintain the graph with the two lines and one column data set when 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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"chris46521" <[email protected]> wrote
in message news:[email protected]...
>
> I have created a pivot table and chart. The pivot chart consists of
> three sets of data from the pivot table. Two of the data sets are lines
> and the third data set is displayed as columns. I made the third data
> set into columns by right clicking on the data series line and
> selecting chart type. I change the chart type for that data set to a
> column and it worked great. The only problem is that when data is
> refreshed in the associated pivot table, the entire chart turns into
> columns with completely different formatting. Does anyone know how I
> can maintain the graph with the two lines and one column data set when
> I refresh the data? Thanks for your help!
>
>
> --
> chris46521
> ------------------------------------------------------------------------
> chris46521's Profile:
> http://www.excelforum.com/member.php...o&userid=35909
> View this thread: http://www.excelforum.com/showthread...hreadid=570934
>