Forum Discussion

jthomson's avatar
jthomson
Solution Sage
7 years ago

Non-numeric y-axis?

Hi,

 

I'm looking to create some visuals (either a scatter plot or a line graph probably) to show how competitors in a series of events have done. My data looks a lot like this:

 

PlayerEvent 1Event 2Event 3

Dan

WinLast 16Last 16
BobSemi FinalQuarter FinalWin
AndyLast 32Quarter FinalLast 64
MikeQuarter FinalWinRunner Up
SteveSemi FinalLast 32Did Not Play
GaryDid Not PlayRunner UpLast 16

 

Except it's for 20+ events and ~100 players. What I want to do is create a graph that looks something like this:

 

 

where the red line shows Dan's performance, the blue Bob's etc.

 

X-axis isn't a problem, I just unpivot everything apart from the player column and then relate it to an ordering table (i.e. two columns saying event 1, 1; event 2, 2 etc) and sort by column to get things ordered. To get the actual graph also isn't a problem, I just convert values in Power Query (i.e. change win to 6, runner up to 5, semi final to 4 and so on. Where I'm stuck is labelling the y-axis. I can only get it showing values from 0-6 - I know I'm going to have to have numeric data to generate the graph, but can I relate that numeric data to what the numerical values represent somewhere in order to get the y-axis displayed like in the image?

 

I can work around by removing the y-axis and putting in text boxes, but as I'm going to have three or four of these graphs on my final report I'd rather not have to fiddle like that. I also can't use any custom visuals for this. Any ideas? Thanks in advance

 

(edited title)