I have written some custom macros in previous versions of Excel that count on
the ability to be able to select data points in a Scatter Plot and move them
in X/Y. I put Command Buttons on the chart that would then run the macro.
(Think Bezier curve control points - move the point, re-calculate the curve).

I believe the feature in previous versions of Excel was called Graphical
Goal Seek (at least that is what the Undo button says after a point is
moved). I cannot seem to get this to work in Excel 2007.

Furthermore, the selection of points in a Data Series in a Scatter Plot is
not consistent with previous versions of Excel. In previous versions, you
clicked the data series, waited a second, then clicked the point that you
wanted to move. In an old spreadsheet with multiple separate XY Scatter
Plots, the selection of individual data points in inconsistent.

Any suggestions on how to re-enable Graphical Goal Seek (Excel patch?,
macro?, some other method?). Why was this changed in the first place?

Thanks,
Bob