Hi there

I want to be able to create a ranking graph in Analytics/BI, with 1 at the top of the Y axis, but I am unable to invert the axis.  Super simple example in Excel below.

Higher rankings need to be higher up on the graph to give the correct visual effect for the user (line goes up as ranking goes up and the plotted values equal the ranking).

Any suggestions?

Many thanks

Duncan