How to put dim table information onto the chart axis?

[Nietzsche]

hello,

just wondering how can I put information from a dim table into the y-axis label?

like this, instead of rating number in the y-axis, I want the texts "above and Beyond", "Exceeds Expectation", "Meets expectation" etc.  

I have a graph of average of self-rating by year.

Thanks.

[AliceW · Accepted solution]

You can't with this type of visual. The values go in there, hence you have something to show on the line...

Try a scatter chart. Not a fan myself, but... 🙂

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution @AliceW  provided, and i want to offer some more infotmation for user to refer to.

hello @Nietzsche , in line chart, the y-axis cannot put the text to it, it need to return the value that is number type, if you want to display the string, you can consider to put it to the legend.

Or you can put the information to the tooltip, when you hold at one place at the visual, it will display at the tooltip.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AliceW · Accepted solution]

You can't with this type of visual. The values go in there, hence you have something to show on the line...

Try a scatter chart. Not a fan myself, but... 🙂