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