Data label in the graph not showing percentage option. only value coming

%3CLINGO-SUB%20id%3D%22lingo-sub-2742051%22%20slang%3D%22en-US%22%3EData%20label%20in%20the%20graph%20not%20showing%20percentage%20option.%20only%20value%20coming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742051%22%20slang%3D%22en-US%22%3E%3CP%3ETeam%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENormally%20when%20you%20put%20a%20data%20label%20onto%20a%20graph%2C%20it%20gives%20you%20the%20option%20to%20insert%20values%20as%20numbers%20or%20percentages.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20current%20graph%2C%20which%20I%20am%20developing%2C%20the%20percentage%20option%20not%20showing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnclosed%20is%20the%20screenshot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20to%20bring%20the%20percentage%20option%20as%20well%20in%20this%20graph%20data%20label%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20Regards%2C%3C%2FP%3E%3CP%3EDipil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2742051%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742121%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20label%20in%20the%20graph%20not%20showing%20percentage%20option.%20only%20value%20coming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1152842%22%20target%3D%22_blank%22%3E%40Dipil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20you%20may%20apply%20another%20format%20to%20data%20labels%2C%20includes%20per%20cents%2C%20but%20not%20to%20force%20percentage%20calculation%20within%20labels.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742129%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20label%20in%20the%20graph%20not%20showing%20percentage%20option.%20only%20value%20coming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanks.%20Generally%20both%20options%20coming%20for%20the%20data%20label.%20Value%20%26amp%3B%20percentage.%20Any%20way%20I%20can%20bring%20back%20the%20Percentage%20option%3F%20Any%20setting%20changes%20required%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20example%20of%20a%20similar%20graph%20enclosed%2C%20in%20which%20I%20am%20getting%20both%20options%20of%20value%20and%20percentage.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20bring%20the%20percentage%20value%20is%20my%20concern.%20Please%20suggest.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742278%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20label%20in%20the%20graph%20not%20showing%20percentage%20option.%20only%20value%20coming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1152842%22%20target%3D%22_blank%22%3E%40Dipil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20for%20Pie%20Chart.%20Each%20chart%20type%20could%20have%20their%20own%20settings%20which%20are%20not%20available%20in%20other%20charts%20since%20they%20are%20not%20applicable%20to%20them.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742471%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20label%20in%20the%20graph%20not%20showing%20percentage%20option.%20only%20value%20coming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks.%20I%20think%20you%20are%20right%3F%20Is%20there%20any%20way%2C%20I%20can%20bring%20the%20percentage%20to%20my%20graph%3F%20Through%20any%20other%20formula%20or%20so%2C%20without%20creating%20another%203%20columns%20and%20plotting%20graph%20separately%20and%20attaching%20to%20this%20graph.%20Please%20share%20your%20views.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Team,

 

Normally when you put a data label onto a graph, it gives you the option to insert values as numbers or percentages. 

 

In the current graph, which I am developing, the percentage option not showing. 

 

Enclosed is the screenshot.

 

Can anyone help me to bring the percentage option as well in this graph data label?

 

Thanks & Regards,

Dipil

8 Replies

@Dipil 

IMHO, you may apply another format to data labels, includes per cents, but not to force percentage calculation within labels.

@Sergei Baklan thanks. Generally both options coming for the data label. Value & percentage. Any way I can bring back the Percentage option? Any setting changes required? 

 

See the example of a similar graph enclosed, in which I am getting both options of value and percentage. 

 

How to bring the percentage value is my concern. Please suggest. Thanks. 

@Dipil 

That's for Pie Chart. Each chart type could have their own settings which are not available in other charts since they are not applicable to them. 

@Sergei Baklan Thanks. I think you are right? Is there any way, I can bring the percentage to my graph? Through any other formula or so, without creating another 3 columns and plotting graph separately and attaching to this graph. Please share your views. 

@Dipil 

You need helper columns but you don't need another chart. Add columns with percentage and use "Values from cells" option to add it as data labels

image.png

@Sergei Baklan Thanks. It's a tedious process if I have to add helper columns. I have more than 100 such graphs in one excel. Thanks for your support. Keep well and stay safe. Cheers!

@Dipil 

Thank you. Copy/paste helper columns and is not a big issue, copy/paste charts with applying new ranges more complex, but I don't know how to do that apply automatically new data labels from ranges. Maybe some VBA code pattern exists, don't know, never seen such.

Good luck!

 

@Sergei Baklan Thanks. The best would be to bring back the percentage option along with the value in the data table. I am not sure if there is a possibility for this. Let's see if anyone else from the larger community has a say on this. Keep well.