Pivot Chart Data Label Formatting Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2742820%22%20slang%3D%22en-US%22%3EPivot%20Chart%20Data%20Label%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20pivot%20chart.%20I%20format%20the%20data%20labels%2C%20for%20example%20make%20the%20text%20larger%20or%20turn%20it.%20Every%20time%20I%20refresh%20the%20data%20the%20data%20label%20formatting%20reverts%20to%20the%20default.%26nbsp%3BI%20have%20gone%20to%20the%20Pivot%20Chart%20options%20and%20made%20sure%20the%26nbsp%3B%3CEM%3EPreserve%20cell%20formatting%26nbsp%3B%3C%2FEM%3Eoption%20is%20checked.%20How%20to%20I%20get%20around%20this%20and%20preserve%20my%20data%20label%20formatting%20when%20the%20data%20is%20refreshed%3F%20Many%20thanks.%20Louis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2742820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2743152%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%20Data%20Label%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2743152%22%20slang%3D%22en-US%22%3EAre%20you%20sure%20that%20the%20%22Preserve%20cell%20formatting%20on%20update%22%20in%20Pivot%20Table%20Options%20is%20checked%3F%3CBR%20%2F%3EDid%20you%20format%20the%20data%20labels%20after%20applying%20any%20kind%20of%20filters%20using%20slicers%20etc%3F%3CBR%20%2F%3EIt%20seems%20to%20be%20a%20kind%20of%20bug%20though%20and%20you%20may%20need%20to%20create%20the%20pivot%20chart%20from%20scratch%20after%20removing%20all%20the%20slicers%20and%20make%20sure%20that%20%22Preserve%20cell%20formatting%20on%20update%22%20is%20checked%20first%20in%20the%20underlying%20Pivot%20Table%20and%20then%20insert%20the%20Pivot%20Chart%20and%20Slicers%20if%20any%20and%20see%20if%20that%20resolves%20the%20issue%20for%20you.%3C%2FLINGO-BODY%3E
Occasional Contributor

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 the Pivot Chart options and made sure the Preserve cell formatting option is checked. How to I get around this and preserve my data label formatting when the data is refreshed? Many thanks. Louis.

 

1 Reply
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.