ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel graph transformations (https://www.excelbanter.com/excel-programming/378469-excel-graph-transformations.html)

[email protected]

excel graph transformations
 
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



All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com