ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Drag datapoints in excel 2007 chart (https://www.excelbanter.com/charts-charting-excel/159013-drag-datapoints-excel-2007-chart.html)

Mister Blobby 6058

Drag datapoints in excel 2007 chart
 
In the older versions, you could drag plotted points on chart, which would
then update the source data either directly or through goalseek if the chart
was plotting a formula.

This was particularly useful for smoothing data to better suit a trendline.

With 2007 however, this facility seems to have been turned off. Is there a
way to turn it back on?

Jon Peltier

Drag datapoints in excel 2007 chart
 
This capability has been removed from Excel 2007. Other users have already
expressed their disappointment.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mister Blobby 6058" <Mister Blobby wrote in
message ...
In the older versions, you could drag plotted points on chart, which
would
then update the source data either directly or through goalseek if the
chart
was plotting a formula.

This was particularly useful for smoothing data to better suit a
trendline.

With 2007 however, this facility seems to have been turned off. Is there a
way to turn it back on?





All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com