Line chart - percentage based on result on last row

[WiserG1980]

Hi gurus.

I'm trying to create S-curve with two series of values.

For the X-axis, however, I'd like to show data as a percentage of the series' last value. Idea is that both lines should end up 100% even though they have different end values. Any ideas how I can do that?

 

[WiserG1980]

Image didn't show. See this for a snippet showing what I have (Pivot and chart):

https://ibb.co/cbjUt7