Excel chart labels keep coming back

%3CLINGO-SUB%20id%3D%22lingo-sub-2971272%22%20slang%3D%22en-US%22%3EExcel%20chart%20labels%20keep%20coming%20back%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2971272%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20data%20set%20that%20I%20have%20changed%20the%20data%20labels%20for%20to%20reflect%20the%20total%20count%20of%20the%20objects%20in%20a%20functional%20category%20(vertical%20axes)%20with%20the%20bars%20of%20the%20chart%20broken%20up%20by%20the%20material%20type%20of%20the%20objects%20in%20the%20functional%20category.%26nbsp%3B%20I%20deleted%20the%20labels%20that%20I%20do%20not%20need%20in%20excel%20but%20whenever%20I%20try%20to%20add%20the%20chart%20into%20my%20word%20document%20all%20the%20labels%20I%20previously%20debleated%20come%20back.%20also%20when%20I%20save%20my%20excel%20workbook%20and%20close%20out%20and%20re%20open%20all%20the%20data%20labels%20are%20back%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20there%20is%20a%20way%20to%20prevent%20these%20unnecessary%20labels%20from%20coming%20back%20beside%20taking%20a%20screen%20shot%20of%20the%20chart%20and%20or%20making%20text%20boxed%20for%20each%20of%20them%20and%20turn%20of%20data%20labels%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2971272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a data set that I have changed the data labels for to reflect the total count of the objects in a functional category (vertical axes) with the bars of the chart broken up by the material type of the objects in the functional category.  I deleted the labels that I do not need in excel but whenever I try to add the chart into my word document all the labels I previously debleated come back. also when I save my excel workbook and close out and re open all the data labels are back as well. 

 

Does anyone know if there is a way to prevent these unnecessary labels from coming back beside taking a screen shot of the chart and or making text boxed for each of them and turn of data labels?

0 Replies