Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 : Cant move data values (scattered points) in XY Scatter c | Setting up and Configuration of Excel | |||
labeling data points on a scatter chart | Charts and Charting in Excel | |||
Macro to add labels to data points in an xy scatter chart | Charts and Charting in Excel | |||
Data Points in Scatter Chart | Charts and Charting in Excel | |||
How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel |