Dragging graph-points to change data? (!)
 

?:

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...


(*)
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

Dragging graph-points to change data? (!)
 

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.


"rememberkindness" wrote in
message ...
?:

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...


(*)
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

Dragging graph-points to change data? (!)
 

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/ti...lue/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

In article ,
says...
?:

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...


(*)
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