Pivot chart refresh - where did my formating go?

fletch

Board Regular
Joined
Jan 6, 2003
Messages
99
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?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
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 :p
 

fletch

Board Regular
Joined
Jan 6, 2003
Messages
99
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,321
Messages
5,571,538
Members
412,402
Latest member
xam99
Top