I am running Excel2000. I wish to create a XY scatter chart (that's easy) and then adjust or change individual point x,y values by selecting the point on the chart/graph and "moving it" with the cursor. Sort of a "drag the point" approach. I think I know how I might do this, but if anyone has already worked out an approach, I would certainly like to hear about it.
Thanks
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Hi,
This functionality is already available in a chart.
Select the series and then select the point. You can now drag the point up/down or left/right and the cell data will update accordingly.
Or did you mean something else?
Cheers
Andy
thanks for the reply. I should have been clearer. I am running Excel2000; that functionality is not in Excel2000 -- at least no in any build I have ever seenOriginally Posted by Andy Pope
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
It's certainly available in line charts. I don't have 2000 here, but used this functionality the other day.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
It's is available in xl2k. The only difference is that I think you are restricted to either horizontal or vertical movement in one drag operation.
Cheers
Andy
I just tried it again and can not make it work.My particular case is a fairly simple XY (scattergram) plot. I have tried draging points vertically, horizontally, both, etc., and nothing happens.
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Time to try a "repair" of Office 2000?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
is this a general comment or is there a known repair or update that fixes this problem?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Really a general comment, but I can't think what else to suggest when such built-in functionality ceases to work.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Make sure your series data is "linked to source" otherwise, dragging the point won't work (i.e. it will not update the value behind it properly)
I have xl2000 and it works for almost every graph I have made (I know because i don't want them to be linked to source so I had to "undo" that linkage)
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
thanks for the reply. How do I determine if the series is "linked to source"? I do know that if I change any of the cell values from which the chart is made, the chart points move immediately.
What build/SR of xl2K are you running? My CD is SR-1. I have used this CD on many different computers and tried upgrading now and again. I find that each upgrade adds no functionality (have not checked this issue of moveable points yet) and lots of new problems. For example, I can not upgrade to SR2 or above and still be able to use Help in ANY MS appl. Based on feedback from several MVPs, MS added security upgrades to SR2 and SR3 and in doing so hammered the Help functionality.
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Even with a series of fixed values I am able to drag and update a specific pointMake sure your series data is "linked to source" otherwise, dragging the point won't work (i.e. it will not update the value behind it properly)
=SERIES(,{1,2,4.28,4},{1,2,1.24,4},1)
Cheers
Andy
Andy: per your earlier reply and my reply to that ... How do I determine if the series is "linked to source"?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
They should, by default be linked to the source. I have created multiple graphs of line and scatter point and been able to manipulate the values by clicking the point on the series and moving it ...
Some chart types have the option on the chart type ( I know I have seen it, just can't find it now)...
I am not sure why you cannot change the values by moving the points, I have not been able to duplicate the issue.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Few ways to check.
Right click chart and pick Source Data. Use the series tab to pick a series and see whether the value and or categories are range/name references.
Select a specific series and see the SERIES() formula in the formula bar.
Are you unable to move the points on any xy scatter chart you create or just one sepcific chart? Can you post an example?
Cheers
Andy
Posting Permissions
Reply With Quote
