View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
wamiller36 wamiller36 is offline
external usenet poster
 
Posts: 7
Default Edit Chart to Change Source Data

Thank you, Mike. I will go a different path.

wam



"Mike Middleton" wrote:

wamiller36 -

Is there a way to do this in Excel 2007? <


No. It's what Microsoft calls a "deprecated" feature.

Any suggestions?


Use Excel 2003 or earlier.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"wamiller36" wrote in message
...
Background:
A decade-plus ago, Excel would allow you to create a chart (based upon
cell
data), then allow you to select a datapoint in the chart, and literally
drag
the datapoint, resulting in a change to the cell data value. This was
great
for visually doing 'what if' examinations (a poor man's method of NOT
having
to use Goal Seeks!).

This capability died out at some point.

Is there a way to do this in Excel 2007? Any suggestions?