Replacing numbers with text on the y-axis of a bar chart
I have a bar chart which currently shows the numeric values we have assigned to specific grades of staff - however, I want to change this so that the y-axis shows the grade title of the staff rather than the grade value which we have created.
I entered the following in the Load Script but can't seem to be able to change the y-axis to the titles.
dual(Text,Number) as Grade
Senior Associate 3,6
Senior Associate 2,5
Senior Associate 1,4
Not sure what the issue is. Any help would be appreciated. I summarise the titles and values below.