---------------------- multipart/mixed attachment >>My dream is to be able to click drag the spline points interactively on >>the chart to adjust the spline curve relative to the existing data and >>have the new spline points calculated after each click and drag. Any >>ideas how that could be done? >> >>David Stanwood > >You can. Drag one of the spline points up or down, and see what happens. It >displays the changed value, and asks you which cell to change to get that >value. You click on the appropriate data cell (in column 3), and it >updates. It's sort of cumbersome, but it does work. > >Ron N Nicely done Ron! If you use the <note,weight> pairs as inputs to an X,Y scatter graph, Excel will calculate and draw the spline for you (I don't know how you get the numbers out, though). Then when you drag a point on the graph, there is no ambiguity about which data to update and it just does it. I expect the spline it draws would match pretty closely the one you're calculating. Easy enough to check. -Mark ---------------------- multipart/mixed attachment A non-text attachment was scrubbed... Name: chart.jpg Type: image/pjpeg Size: 64039 bytes Desc: not available Url : https://www.moypiano.com/ptg/pianotech.php/attachments/3d/62/75/eb/chart.jpg ---------------------- multipart/mixed attachment--
This PTG archive page provided courtesy of Moy Piano Service, LLC