 |
 | 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 / April 2008Change spreadsheet by moving graph points?
I am trying to find a way to move a graph point around and then have it tell me what the new number would be in my spreadsheet? Is this possible? It used to be. If you haven't upgraded to Excel 2007, it still is possible. Select the point (one single click to select the series, another to select the point). If it's a marker, put the cursor over the point and it will become a 2-headed arrow (line chart) or 4-headed arrow (XY chart). If it's a bar or column, put the cursor at the end of the bar and it will become a 2-headed arrow. Drag this arrow to change the value being plotted. The cell containing the value will change. If the cell contains a formula, Excel's Goal Seek function will be activated to let you decide which input to the formula will result in the changed value. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I am trying to find a way to move a graph point around and then have it >tell > me what the new number would be in my spreadsheet? Is this possible? This feature of using a data point on the graph to goal seek was the best tool in excel's arsenal. Why was it removed? I urge others not to upgrade to excel 2007 until it is restored. I 'm grateful for the 60 day trial, otherwise I would have wasted money on a progam that is less powerful then excel 97. > I am trying to find a way to move a graph point around and then have it tell > me what the new number would be in my spreadsheet? Is this possible? This hasn't been addressed to date! Why would they remove this feature? Unfortunately I can't downgrade at this point, but agree with Kendal, do not upgrade to 2007, not worth the trouble! normal > I am trying to find a way to move a graph point around and then have it tell > me what the new number would be in my spreadsheet? Is this possible? Not in Excel 2007 but in earlier versions. best wishes > normal > >> I am trying to find a way to move a graph point around and then have it >> tell >> me what the new number would be in my spreadsheet? Is this possible? |
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.