| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change 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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change spreadsheet by moving graph points?
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 _______ "CourtneyNeedsHelp" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change spreadsheet by moving graph points?
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. "CourtneyNeedsHelp" wrote: 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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change spreadsheet by moving graph points?
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! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
cauque um
normal
"CourtneyNeedsHelp" escreveu: 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? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
cauque um
Not in Excel 2007 but in earlier versions.
best wishes "cassio171" wrote in message ... normal "CourtneyNeedsHelp" escreveu: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Less points in graph | Excel Worksheet Functions | |||
| Dragging graph-points to change data? (!) | Excel Discussion (Misc queries) | |||
| Dragging graph-points to change data? (!) | Charts and Charting in Excel | |||
| Dragging graph-points to change data? (!) | Excel Worksheet Functions | |||
| all points on a xy graph | Charts and Charting in Excel | |||
Hybrid Mode
