Dragging graph-points to change data? (!)

[rememberkindness]

?:

Who knows:

a) how soon either Excel or PowerPoint might allow changes to data by
directly re-forming the data's graph(chart)
(e.g. by mouse-dragging edges, bar-ends, or other such elements),

or

b) whether there is an add-on (or auxiliary app) already available (or that
someone is working on) to enable such data-altering in those two main apps,

or

c) someone who might like to help make &/or sell such an add-on for one or
more such popular apps

?


Thanks!

& do pls. fwd this to all you think might be able to help us out...

(e-mail address removed)
(e-mail address removed) (*)
Ph. (U.S.) 206.355.7185 or 406.661.1319
POB 95331 Seattle WA 98145-2331 USA

- - - - -
(* "Only our love will end hatred. This is an eternal law."
--Shakya-muni Buddha, 'Dhammapada' Ch. 5
"Love your enemies; do good to those who hurt you; bless those who
persecute you..."
-- Yeshuah {"Jesus"}, Mt.5:39f, Lk.6:27f

 

[Kelly O'Day]

Excel lets you change individual chart points by selecting point and moving
it to new location. Source data is then changed to new X, Y position.

 

[Tushar Mehta]

You can already do this in XL!

Click a point to select the entire plotted series. Pause. Click the point
again. Now, click and drag up or down. If the plotted point corresponds to
a number in a cell, that number will be changed. If it is a formula, XL
will show a Goal Seek dialog so that the actual source can be changed
appropriately.

That technique is used as a part of
Read X and Y value of any point on a chart
http://www.tushar-mehta.com/excel/tips/read_chart_value/index.html

and

the goal seek part is documented in
http://www.hull.ac.uk/ict/excexpwhatif_133.pdf

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions