Prev: Automatically vary range in graph depending on #rows data entered?
Next: Chart Help
From: wamiller36 on 1 Jul 2008 17:13
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?
From: Mike Middleton on 1 Jul 2008 21:05
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" <wamiller36(a)discussions.microsoft.com> wrote in message
news:37C8A1E9-E851-4A19-8B52-5615411A4D9B(a)microsoft.com...
> 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?


From: wamiller36 on 2 Jul 2008 02:17
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" <wamiller36(a)discussions.microsoft.com> wrote in message
> news:37C8A1E9-E851-4A19-8B52-5615411A4D9B(a)microsoft.com...
> > 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?
>
>
>
 | 
Pages: 1
Prev: Automatically vary range in graph depending on #rows data entered?
Next: Chart Help