W
wamiller36
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?
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?