|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 30th, 2009, 08:23 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
drag point on line chart to change data in associated cell
This same file is working in excel 2000, now using 2007. I have a line chart
that is made up of cell data. I want to select a data point on the line chart and drag it up or down and have it change the data in the associated cell... this is used as input data for other functions... 
|
|
#2
October 31st, 2009, 03:42 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
drag point on line chart to change data in associated cell
Unfortunately, that was removed in Office 2007
A number of users have asked to have it back but it is not present in the Tech Preview version of Excel 2010 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "cmax" wrote in message ... This same file is working in excel 2000, now using 2007. I have a line chart that is made up of cell data. I want to select a data point on the line chart and drag it up or down and have it change the data in the associated cell... this is used as input data for other functions...
|
|
#3
October 31st, 2009, 08:41 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
drag point on line chart to change data in associated cell
Excel 2007 Chart
Move points, change data. A work-around. http://www.mediafire.com/file/y2ngq1lx3mn/10_31_09.xlsm
|
|
#4
November 2nd, 2009, 05:10 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
drag point on line chart to change data in associated cell
Excel 2007 Chart
Move points vertically and horizontally http://www.mediafire.com/file/jtyzyj...10_31_09a.xlsm
|
|
#5
November 3rd, 2009, 04:22 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
drag point on line chart to change data in associated cell
Microsoft has released an add-in which lets you select a series and
point, then use sliders to adjust the X and Y coordinates of the point. Excel Add-In for Manipulating Points on Charts (MPOC) http://blogs.msdn.com/excel/archive/...arts-mpoc.aspx - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ cmax wrote: This same file is working in excel 2000, now using 2007. I have a line chart that is made up of cell data. I want to select a data point on the line chart and drag it up or down and have it change the data in the associated cell... this is used as input data for other functions...
|
|
#6
November 3rd, 2009, 07:43 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
drag point on line chart to change data in associated cell
Thanks for the info Jon, I missed it.
Misange http://www.excelabo.net Jon Peltier a écrit : Microsoft has released an add-in which lets you select a series and point, then use sliders to adjust the X and Y coordinates of the point. Excel Add-In for Manipulating Points on Charts (MPOC) http://blogs.msdn.com/excel/archive/...arts-mpoc.aspx - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ cmax wrote: This same file is working in excel 2000, now using 2007. I have a line chart that is made up of cell data. I want to select a data point on the line chart and drag it up or down and have it change the data in the associated cell... this is used as input data for other functions...
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
