Pivot chart refresh - where did my formating go?

[fletch]

I've created a pivot chart. When I refresh it the secondary access and data series formating returns to a default. How can i prevent this?

 

[Andrew Poulsom]

Here is Microsoft's solution:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904

 

[Greg Truby]

AFAIK you can't. Irritates the soup outta me too. About the most I've been able to do is to alter the pallet colors -- tools | options | color (tab) and the bottom set of sixteen "custom colors" are the charting pallet. But do anything fancy like shaded fills or fill with a picture and it all evaporates when you click on any of the field-changing buttons.

Just saw Andrew's post when I "previewed" this. So, looks like we can't stop it from happening, only undo the mess by dragging VBA into it and restoring the formatting that way. yuk

 

[fletch]

Thanks guys,

I can write the vb to reformat the chart. ideally i'd like the macro to automatically run when I change the value in the page pivotchart button (top left).

Is this possible?

 

[Andrew Poulsom]

The Calculate event will fire when you change the Page field.