Forum Discussion
Data label in the graph not showing percentage option. only value coming
SergeiBaklan 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.
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.
SergeiBaklan 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.
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
SergeiBaklan 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!