Line Chart with X-Axis based on Index-Percentage of Data Range

[AdamantLife]

Hey There,

I have several series of data which are of variable lengths and value distributions but have similar endpoints, eg:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Series 1[/TD]
[TD]50[/TD]
[TD]75[/TD]
[TD]125[/TD]
[TD]150[/TD]
[TD]200[/TD]
[TD]225[/TD]
[TD]275[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Series 2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]12[/TD]
[TD]18[/TD]
[TD]27[/TD]
[TD][continued
further][/TD]
[/TR]
[TR]
[TD]Series 3[/TD]
[TD]60[/TD]
[TD]105[/TD]
[TD]184[/TD]
[TD]322[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I was hoping to be able to chart these series relative to their own completion (in other words, such that they all ended at 100%). I have tried manually generating the X(%)-Values in another table that looks like this:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Series 1[/TD]
[TD]12.5%[/TD]
[TD]25%[/TD]
[TD]37.5%[/TD]
[TD]50%[/TD]
[TD]62.5%[/TD]
[TD]75%[/TD]
[TD]87.5%[/TD]
[TD]100%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Series 2[/TD]
[TD]7.14%[/TD]
[TD]14.29%[/TD]
[TD]21.43%[/TD]
[TD]28.57%[/TD]
[TD]35.71%[/TD]
[TD]42.86%[/TD]
[TD]50%[/TD]
[TD]57.14%[/TD]
[TD][etc.][/TD]
[/TR]
[TR]
[TD]Series 3[/TD]
[TD]25%[/TD]
[TD]50%[/TD]
[TD]75%[/TD]
[TD]100%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I entered a number of the series into a Line Chart by hand, using "Add Series," and putting the Percentage-Table's range in the X-Axis entry box and the Data-Table's range in the Y-Axis entry box. Unfortunately, the Chart is graphing the data based on the index of the Percentage-Table's range: in other words, the X-points for all the ranges graphs at 1 to start (instead of, ex., 12.5%, 7.14%, 25%) and end at whatever the last index is (ex., 8,15,4).

The only other method I thought of was to make a table with header values of 1%-100% (I'm sure, though, requiring smaller increments) and having the table cross-reference the other two tables to place each number from the first table onto the third table in the percentage column dictated by the second table. This, however, seemed a bit too convoluted, so I was hoping to learn a better way of graphing it.

Thanks in advance!