Forum Discussion
Pivot Chart Data Label Formatting Question
Hi, I have a pivot chart. I format the data labels, for example make the text larger or turn it. Every time I refresh the data the data label formatting reverts to the default. I have gone to th...
Are you sure that the "Preserve cell formatting on update" in Pivot Table Options is checked?
Did you format the data labels after applying any kind of filters using slicers etc?
It seems to be a kind of bug though and you may need to create the pivot chart from scratch after removing all the slicers and make sure that "Preserve cell formatting on update" is checked first in the underlying Pivot Table and then insert the Pivot Chart and Slicers if any and see if that resolves the issue for you.
Did you format the data labels after applying any kind of filters using slicers etc?
It seems to be a kind of bug though and you may need to create the pivot chart from scratch after removing all the slicers and make sure that "Preserve cell formatting on update" is checked first in the underlying Pivot Table and then insert the Pivot Chart and Slicers if any and see if that resolves the issue for you.
I was experiencing the same issue as OP. I deleted the chart to recreate it again from scratch. This seemed to remedy this issue. All formatting is preserved upon data refresh, for now. Must be a bug.