ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dragging graph-points to change data? (!) (https://www.excelbanter.com/excel-programming/368200-dragging-graph-points-change-data.html)

rememberkindness

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

Bernard Liengme

Dragging graph-points to change data? (!)
 
1) But in Excel you already can do this. Make an XY chart and drag a point
up or down
2) In A1:A4 enter 1,2,3,4 in B1 enter =2*A1 and copy down to B4; make XY or
Line chart and grade a point up or down - Goal Seek pops up
Shame all wishes cannot be granted so easily!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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




Jim Thomlinson

Dragging graph-points to change data? (!)
 
That functionallity already exist. Select an individual point on a data
series and drag it up or down to change the source data. Make sure when you
select that you are grabbing an individual point and not the entire series...
--
HTH...

Jim Thomlinson


"rememberkindness" wrote:

?:

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



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

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