Hi
I'm making a spreadsheet that tracks game data in League of Legends. In ranked mode you're placed in a division and have "LP" (points from 0-100 where 100 can promote you to a higher division).
So I wanna make a chart of this and what i have is shown in this image:
https://imgur.com/NTlJKw8
The way i chart it is an extra table column called RankValue where i give each division 101 points, so for example the worst is 0 points and 0 points in the second-worst division is 101 points. Hope it makes sense
Here is a screenshot of the values for my last few matches (left column):
https://imgur.com/0FsxaK9
As seen in the first screenshot - on the Pivot chart i have these RankValue "fake points" on my y-axis and thus it's also what's shown when i hover a point on the chart.
However what I want to show is the thing in the second column on the second screenshot (i can live with no axis since).
Is that possible?
Hope all this makes sense.
Thanks in advance
I'm making a spreadsheet that tracks game data in League of Legends. In ranked mode you're placed in a division and have "LP" (points from 0-100 where 100 can promote you to a higher division).
So I wanna make a chart of this and what i have is shown in this image:
The way i chart it is an extra table column called RankValue where i give each division 101 points, so for example the worst is 0 points and 0 points in the second-worst division is 101 points. Hope it makes sense
Here is a screenshot of the values for my last few matches (left column):
https://imgur.com/0FsxaK9
As seen in the first screenshot - on the Pivot chart i have these RankValue "fake points" on my y-axis and thus it's also what's shown when i hover a point on the chart.
However what I want to show is the thing in the second column on the second screenshot (i can live with no axis since).
Is that possible?
Hope all this makes sense.
Thanks in advance
