ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   plot points (https://www.excelbanter.com/charts-charting-excel/232542-plot-points.html)

twotrack

plot points
 
Is there a way to change the data points in a chart automatically if a plot
point is changed (such as dragging the line point to a new axis value)?

Bernard Liengme

plot points
 
In classical Excel, a point on a chart could be dragged and the data table
would change (with an XY chart -- can't recall if it works with other
charts). But this feature was (unfortunately) left out of Excel 2007
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"twotrack" wrote in message
...
Is there a way to change the data points in a chart automatically if a
plot
point is changed (such as dragging the line point to a new axis value)?



acka

plot points
 
On Jun 1, 8:07*pm, "Bernard Liengme"
wrote:
In classical Excel, a point on a chart could be dragged and the data table
would change (with an XY chart -- can't recall if it works with other
charts). But this feature was (unfortunately) left out of Excel 2007
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme

"twotrack" wrote in message

...



Is there a way to change the data points in a chart automatically if a
plot
point is changed (such as dragging the line point to a new axis value)?- Hide quoted text -


- Show quoted text -


I'm new to the group so please tell me if there is a way of doing
this, but I'd just like to register another voice saying that losing
the point-dragging functionality from Excel 2003 XY charts is a really
backward step. I have a classroom exercise which is centred around
this functionality - I'm not happy about losing the time invested in
developing it.


All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com