Pivot Chart changes chart upon refresh
 

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

Pivot Chart changes chart upon refresh
 

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" wrote
in message ...

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