Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
How do I edit replace source data links for a chart? | Charts and Charting in Excel | |||
Change source data in a pivot chart | Charts and Charting in Excel | |||
Can't change source data path for Pivot Chart | Charts and Charting in Excel |