 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2008Graphical Goal Seek - Excel 2007
I have written some custom macros in previous versions of Excel that count on the ability to be able to select data points in a Scatter Plot and move them in X/Y. I put Command Buttons on the chart that would then run the macro. (Think Bezier curve control points - move the point, re-calculate the curve). I believe the feature in previous versions of Excel was called Graphical Goal Seek (at least that is what the Undo button says after a point is moved). I cannot seem to get this to work in Excel 2007. Furthermore, the selection of points in a Data Series in a Scatter Plot is not consistent with previous versions of Excel. In previous versions, you clicked the data series, waited a second, then clicked the point that you wanted to move. In an old spreadsheet with multiple separate XY Scatter Plots, the selection of individual data points in inconsistent. Any suggestions on how to re-enable Graphical Goal Seek (Excel patch?, macro?, some other method?). Why was this changed in the first place? Thanks, Bob Bob Colbert - The "graphical goal seek" feature is not available in Excel 2007. In "Microsoft-speak" that feature has been "deprecated." The selection problem may be one of the many problems that will hopefully be addressed with Office 2007 Service Pack 1. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel >I have written some custom macros in previous versions of Excel that count >on [quoted text clipped - 19 lines] > Thanks, > Bob Do you know if Microsoft is intending to "undeprecate" the graphical goal seek function. I have a series of charts which I review only on an annual basis when new data becomes available. Graphical goalseek enabled me to smooth in the new data and for my modelled spreadsheet data to adjust accordingly. So now I have to construct another way to do this. Like I have time! Why oh why does Microsoft take out facilities that existed in previous products? I swear I will never ever buy another new Microsoft product. How do we the Office consuming public make our voice heard? > Bob Colbert - > [quoted text clipped - 32 lines] > > Thanks, > > Bob Debbie424242 - > Do you know ... < No. > How do we the Office consuming public make our voice heard? < One way: In Excel 2007, choose Office Button | Excel Options | Resources | Contact Us | (Feedback Submission) Suggest new content ... - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel > Do you know if Microsoft is intending to "undeprecate" the graphical goal > seek function. I have a series of charts which I review only on an annual [quoted text clipped - 52 lines] >> > Thanks, >> > Bob Not a solution in Excel 2007, but an option is to uninstall Excel/Office 2007, reinstall Office 2003, then reinstall Office 2007, selecting the custom install. When prompted, opt to keep earlier versions of Office, so one can revert to Excel 2003 to access features that are not available in 2007, assuming that workbooks do not contain features that are totally incompatible with 2007. > Debbie424242 - > [quoted text clipped - 67 lines] > >> > Thanks, > >> > Bob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.