Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 103
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing data points causes my line graph not to connect liebw Charts and Charting in Excel 8 November 24th 08 10:15 PM
Dragging graph-points to change data? (!) rememberkindness Excel Worksheet Functions 1 July 25th 06 01:57 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"