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:

Series 1	50	75	125	150	200	225	275	300
Series 2	1	2	3	5	8	12	18	27	[continued further]
Series 3	60	105	184	322

<tbody>
</tbody>

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:

Series 1	12.5%	25%	37.5%	50%	62.5%	75%	87.5%	100%
Series 2	7.14%	14.29%	21.43%	28.57%	35.71%	42.86%	50%	57.14%	[etc.]
Series 3	25%	50%	75%	100%

<tbody>
</tbody>

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!