Edit Chart to Change Source Data
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? |
Edit Chart to Change Source Data
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? |
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? |
All times are GMT +1. The time now is 12:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com