Inserting Data Label in the Color Legend of a pie chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1550191%22%20slang%3D%22en-US%22%3EInserting%20Data%20Label%20in%20the%20Color%20Legend%20of%20a%20pie%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20insert%20data%20labels%20(percentages)%20as%20part%20of%20the%20side%20colored%20legend%2C%20rather%20than%20on%20the%20pie%20chart%20itself%2C%20as%20displayed%20on%20the%20image%20below.%3C%2FP%3E%3CP%3EDoes%20Excel%20offer%20that%20option%20and%20if%20so%2C%20how%20can%20i%20go%20about%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Graph.jpg%22%20style%3D%22width%3A%20428px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208466i97A978FDC3FFC04C%2Fimage-dimensions%2F428x268%3Fv%3D1.0%22%20width%3D%22428%22%20height%3D%22268%22%20title%3D%22Graph.jpg%22%20alt%3D%22Graph.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1550191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I am trying to insert data labels (percentages) as part of the side colored legend, rather than on the pie chart itself, as displayed on the image below.

Does Excel offer that option and if so, how can i go about it?

 

Graph.jpg

1 Reply

@SabrinaFr 

There is no built-in way to do that, but you can use a trick: see Add Percent Values in Pie Chart Legend (Excel 2010)