percentage option not showing on graph data labels

Copper Contributor

on graphs > data label> more options> label options. there should be percentage value option to convert our bar into percentage but its missing from my file how can I bring it back ? attached the screenshot with this

1 Reply


If we speak about stacked column chart - nothing is missing. To show labels in per cents you may to calculate them outside your source and use for labels Value from Cells.

How to Show Percentages in Stacked Column Chart in Excel? - GeeksforGeeks