Updating my PivotChart removes the formatting of the chart.

Ship_m

New Member
Joined
Oct 4, 2006
Messages
2
My problem is that when I updating my PivotChart it removes the formatting of the chart.

I found the following explanation in MS kb (KB215904) se below.

Dos anybody have a better workaround to this problem?

I have approximately 35 PivotTable/ PivotChart in the workbook that needs updating (and subsequently reformatting) so the workaround mentioned below is not really an option.

MS KB215904
SYMPTOMS
When you perform any of the following pivot operations in your PivotChart or the underlying PivotTable report, one or more of your data series lose their formatting:
• You refresh the PivotChart or the underlying PivotTable.
• You add, remove, or move any fields that you have added to your PivotChart or PivotTable.
• You show or hide individual items in any PivotChart or PivotTable field.

CAUSE
When you perform a pivot operation in a PivotChart or the underlying PivotTable report, Microsoft Excel removes, and then adds the data series back to the chart. When this occurs, all formatting that you have applied to the data series in the chart is lost.

WORKAROUND
To work around this problem, you can record a Visual Basic for Applications macro that saves the changes that you make to your PivotChart. Then, you can run the macro to reapply the formatting as necessary.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Ship_m

New Member
Joined
Oct 4, 2006
Messages
2
Hi Andrew

Thank you for your posting, thou not the answer I was looking for :) but at least I can stop searching high and low for a fix.
Great link.

Have nice day
[/img]
 

Forum statistics

Threads
1,141,403
Messages
5,706,252
Members
421,434
Latest member
DaltonB

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top