Moving Data Points on Scatter Chart in 2007
 

I have used Excel to construct various ship curves in all versions until
2007. I would create a table of offsets (x,y points) and build a simple
integration scheme around the table. I would then graph the offsets. I
could go into the graph, grab a particular data point and move it either
horizontally or vertically. This would update the table and update the
integration. I would have the area (or volume) display on the graph. So I
could fair a smooth curve by adjusting offsets (with the smooth lines turned
on) until I got the area and centroid I needed. Until Excel 2007! I cannot
find a way to grab and move a single data point in this version. Is there a
way to do it? Help?
--
Greg

Moving Data Points on Scatter Chart in 2007
 

That feature is gone. MS thought nobody used it!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"GregW" wrote in message
...
I have used Excel to construct various ship curves in all versions until
2007. I would create a table of offsets (x,y points) and build a simple
integration scheme around the table. I would then graph the offsets. I
could go into the graph, grab a particular data point and move it either
horizontally or vertically. This would update the table and update the
integration. I would have the area (or volume) display on the graph. So
I
could fair a smooth curve by adjusting offsets (with the smooth lines
turned
on) until I got the area and centroid I needed. Until Excel 2007! I
cannot
find a way to grab and move a single data point in this version. Is there
a
way to do it? Help?
--
Greg

Moving Data Points on Scatter Chart in 2007
 

WOW! Can we get it back? I need it badly for I was using it the same way Greg
did while adjusting/fitting the curves...
Henry

"Bernard Liengme" wrote:

That feature is gone. MS thought nobody used it!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"GregW" wrote in message
...
I have used Excel to construct various ship curves in all versions until
2007. I would create a table of offsets (x,y points) and build a simple
integration scheme around the table. I would then graph the offsets. I
could go into the graph, grab a particular data point and move it either
horizontally or vertically. This would update the table and update the
integration. I would have the area (or volume) display on the graph. So
I
could fair a smooth curve by adjusting offsets (with the smooth lines
turned
on) until I got the area and centroid I needed. Until Excel 2007! I
cannot
find a way to grab and move a single data point in this version. Is there
a
way to do it? Help?
--
Greg