![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: chart, curser, data, moved, points, scatter |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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. |
| Ads |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
Excel 2007 Chart
Move points on XY scatter chart. Also scale XY axes. With macro. http://c0444202.cdn.cloudfiles.racks...10_31_09a.xlsm |
|
#4
|
|||
|
|||
|
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/...arts-mpoc.aspx Ed Ferrero www.edferrero.com |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Selecting data points in a scatter chart | Anthony Blackburn | Excel Discussion (Misc queries) | 2 | June 24th 09 04:17 PM |
| Labelling data points in a scatter chart | iaintw | Charts and Charting in Excel | 1 | November 16th 07 12:14 PM |
| labeling data points on a scatter chart | Mr Tee | Charts and Charting in Excel | 1 | March 31st 06 01:15 PM |
| Data Points in Scatter Chart | CWILSON | Charts and Charting in Excel | 2 | January 25th 05 05:41 PM |
| How many data points can you have in an Excel for a Scatter Chart. | gregran | Charts and Charting in Excel | 3 | December 10th 04 08:31 PM |