"Range for Name" changes upper case to lower case

The legend part of a chart that I did is showing all the labels in full lower case (looks unprofessional) and any attempt to change the initial letters to upper case fails as they are automatically changed back to lower case. Help. Thanks.



I can’t reproduce the issue, pls could you share a sample file showing the problem.

Nevermind, I figured it out. The field wasn’t meant to write in the label but to direct the chart to the cell that contains the label.