![]() |
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? (!)
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 |
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