excel graph transformations

[RobZahra]

Suppose you have 100 series paths on a line graph, all linked to data
in a table. The series values each start and end at different points
along the X axis. Is there a built-in and/or quick way to linearly
strech/squash each series (just on the horizontal axis) such that they
all start and end at the same two points on the graph?

Realize I could code out the logic but implementing the linear
interpolation seems unduly messy if there's some chart feature or other
built-in way.

thanks

 

[N10]

Suppose you have 100 series paths on a line graph, all linked to data
in a table. The series values each start and end at different points
along the X axis. Is there a built-in and/or quick way to linearly
strech/squash each series (just on the horizontal axis) such that they
all start and end at the same two points on the graph?

Realize I could code out the logic but implementing the linear
interpolation seems unduly messy if there's some chart feature or other
built-in way.

thanks

Unless I misunderstand what you want to achieve Id say the very nature of
drawing a graph in the first place is the alignment of the coincidence and
value of an y axis series with a proportinate or appropriate x coordinate
..

Surely squashing or stretching data would result in misalignment of
population with refrence to the x axies