Graph visualization values button unclickable

Copper Contributor

This is a 100% stacked column graph, I would like to have the porcentajes shown on each bar so i can know the exact value, however, the button to do so is grayed out. any idea on how to do it? i apologize for having excel in Spanish, you can guide me in English without a problem.Excel help.png

2 Replies

@matirohr 

I guess you need to add data labels to your chart, not format axis.

image.png

 

@Sergei Baklan Yes, i ended up doing that and selecting a custom set of cells where i did the math myself. I was just hoping there was a way to configure the graph to do it automatically. 

 

Anyway, thank you for the help!