drag point on line chart to change data in associated cell

[cmax]

This same file is working in excel 2000, now using 2007. I have a line chart
that is made up of cell data. I want to select a data point on the line chart
and drag it up or down and have it change the data in the associated cell...
this is used as input data for other functions...

 

[Bernard Liengme]

Unfortunately, that was removed in Office 2007
A number of users have asked to have it back but it is not present in the
Tech Preview version of Excel 2010
best wishes

 

[Herbert Seidenberg]

Excel 2007 Chart
Move points, change data.
A work-around.
http://www.mediafire.com/file/y2ngq1lx3mn/10_31_09.xlsm

 

[Herbert Seidenberg]

Excel 2007 Chart
Move points vertically and horizontally
http://www.mediafire.com/file/jtyzyjyojxm/10_31_09a.xlsm

 

[Jon Peltier]

Microsoft has released an add-in which lets you select a series and
point, then use sliders to adjust the X and Y coordinates of the point.

Excel Add-In for Manipulating Points on Charts (MPOC)
http://blogs.msdn.com/excel/archive...n-for-manipulating-points-on-charts-mpoc.aspx

- Jon

 

[Misange]

Thanks for the info Jon, I missed it.

Misange
http://www.excelabo.net


Jon Peltier a écrit :