View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Morten Hvidberg-Knudsen Morten Hvidberg-Knudsen is offline
external usenet poster
 
Posts: 16
Default Is it possible to drag points in an Excel 2007 Scatter Chart?

Well, the reason that this upsets me is that I have used this feature a lot
for removing "outliers" from long lists of data.

Outliers are easily spotted on a plot, so in order to easily delete the
corresponding data point I wrote VB code that caught the
MyChartClass_SeriesChange event (which is raised after dragging a point on a
graph). This event returns the point index of the data being moved to the
event handler. In the event handler I simply cleared the contents of the
corresponding cell in the spreadsheet.

In this way all you had to do to remove outliers from the data list was to
select and drag them on the plot.

Are there in Excel 2007 any other events that can be used for this purpose

Regards

Morten


"Jon Peltier" wrote:

This capability was removed from Excel 2007.

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


"CarltonTheDoorman" wrote in
message ...
In other versions of Excel, dragging points in a Scatter Chart allowed for
editing graph data on the graph rather than by switching back to the data.
Following the same process in Excel 2007 is unsuccessful. Is dragging
data
points possible in Excel 2007?????