Sep 11 2021 12:41 AM
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
Sep 11 2021 01:34 AM
IMHO, you may apply another format to data labels, includes per cents, but not to force percentage calculation within labels.
Sep 11 2021 01:48 AM
@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.
Sep 11 2021 05:43 AM
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.
Sep 11 2021 08:00 AM
@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.
Sep 11 2021 08:41 AM
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
Sep 11 2021 08:47 AM
@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!
Sep 11 2021 12:25 PM
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!
Sep 11 2021 09:09 PM
@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.
Aug 01 2023 01:52 PM
@Dipil I agree, not sure why percentage isn't an option for other chart types like stacked bar charts, etc.