Prev: Secondary axis not aligning to X axis
Next: Chart data scrunches to left when adding X axis date series
From: Carlos Sr Carlos on 7 Feb 2010 22:47
EXCEL 2003 allows data pointa on a scatter chart to be draged from one
location to another. I use this feature a lot to fit an equation with dummy
data points to actual data points. I am unable to do this in EXCEL 2007. I
have asked others with this new system and they were not able find a way to
do it either. Has this function been removed? How can this feature be
activated.
From: trip_to_tokyo on 8 Feb 2010 00:20
According to MS documentation:-

"Direct manipulation of data points: In the past, you could select a data
point in a chart and move it — which also changed the underlying data. This
rarely used action no longer works."

Please hit Yes if my comments have helped.

Thanks.

"Carlos Sr" wrote:

> EXCEL 2003 allows data pointa on a scatter chart to be draged from one
> location to another. I use this feature a lot to fit an equation with dummy
> data points to actual data points. I am unable to do this in EXCEL 2007. I
> have asked others with this new system and they were not able find a way to
> do it either. Has this function been removed? How can this feature be
> activated.
From: Herbert Seidenberg on 8 Feb 2010 14:18
Excel 2007 Chart
Move points on XY scatter chart.
Also scale XY axes.
With macro.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/10_31_09a.xlsm
From: Ed Ferrero on 9 Feb 2010 00:47
Hi Carlos,

You might want to see Microsoft's add-in for this. Still not as good as
XL2003...

http://blogs.msdn.com/excel/archive/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc.aspx

Ed Ferrero
www.edferrero.com

 | 
Pages: 1
Prev: Secondary axis not aligning to X axis
Next: Chart data scrunches to left when adding X axis date series