AdamantLife
New Member
- Joined
- Jun 9, 2015
- Messages
- 1
Hey There,
I have several series of data which are of variable lengths and value distributions but have similar endpoints, eg:
<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:
<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!
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!