Stop Chart Style (Format) Update

[Kevin McCartney]

Hi TWIMC,
I'm using Excel 2000 and I have a pivot table that aggregates data based on REGION, COUNTRY, ZONE etc etc. Once I have set up the chart they way that I would like it to look, if I then make a change to the selection using the pivot chart buttons, e.g. I select a country and the chart re-formats itself back to what appears to be the default style. I've set my chart style to the default but it still doesn't keep my chart style. What I want is that the chart style remains the same but the new values are just plotted onto the chart.

I'm sure there is an option to turn update off but where is it?

Any help much appreciate,

TIA
KM

 

[Jon Peltier]

Kevin -

This is an acknowledged issue with Pivot Charts. Microsoft suggests
recording a macro when you reformat the chart, so you can rerun the
macro next time:

XL2000: Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904

An alternative is to define a custom chart type based on the correctly
formatted pivot chart, and reapply this custom type after updating the
chart. This article demonstrates how to create your own custom chart types:

http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______