Macro to refresh pivots also resets chart data label fonts.

[RickyH]

Hi,

I have 6 pivot charts within a document. I use a macro associated with a button to refresh the tables and therefore the data displayed on the charts.

However, each time I refresh the data, the 'data label' font size also refreshes. What is particularly odd is that 5 of the charts are pie-graphs, of those 5 graphs, the font size only resets on 4 of them (with the data labels in a single chart staying at my desired font size).

I can manualyl put the font size back to that which I desire but I'd rather it just didn't change in the first place.

I've had a look to see if there's any noticeable differences between the 5 charts but there's nothing which I can find.

I'd be happy to run a bit of VBA to set the font size as I want it, if there isn't a better solution.

Cheers Ricky

 

[AvcGJS]

sounds like one of those 'things' excel does... add a line of code to put your fonts back after the refresh