Is it possible to drag points in an Excel 2007 Scatter Chart?

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?????

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" <CarltonTheDoorman@discussions.microsoft.com> wrote in
message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
> 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?????

You cant be serious . Why ????

"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" <CarltonTheDoorman@discussions.microsoft.com> wrote in
> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
> > 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?????
>
>
>

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" <CarltonTheDoorman@discussions.microsoft.com> wrote in
> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
> > 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?????
>
>
>

You could easily adapt one of these approaches:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

start with the simple click to identify a point.

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


"Morten Hvidberg-Knudsen" <MortenHvidbergKnudsen@discussions.microsoft.com>
wrote in message news:C5F0AB0A-F0FA-40CC-8D00-A5264614C392@microsoft.com...
> 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" <CarltonTheDoorman@discussions.microsoft.com> wrote
>> in
>> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
>> > 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?????
>>
>>
>>

Thanks a lot.

And you are right, it is more apropriate to catch the select event.


"Jon Peltier" wrote:

> You could easily adapt one of these approaches:
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=221
>
> start with the simple click to identify a point.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>

2007 crashes:

The code below (using a chart event to "navigate" to a specific cell in the
grid) immediately crashes Excel 2007:
----------
Public WithEvents myChartClass As Chart

Private Sub myChartClass_BeforeDoubleClick(ByVal ElementID As Long, ByVal
Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
If ElementID = xlSeries And Arg2 > 0 Then ' a point in a series
Range("A1").Offset(Arg2).Select
End If
End Sub
------
Similar code in Excel 2003 (using the SeriesChange event though) works fine.

Regards
Morten
"Jon Peltier" wrote:

> You could easily adapt one of these approaches:
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=221
>
> start with the simple click to identify a point.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Morten Hvidberg-Knudsen" <MortenHvidbergKnudsen@discussions.microsoft.com>
> wrote in message news:C5F0AB0A-F0FA-40CC-8D00-A5264614C392@microsoft.com...
> > 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" <CarltonTheDoorman@discussions.microsoft.com> wrote
> >> in
> >> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
> >> > 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?????
> >>
> >>
> >>
>
>
>

Try qualifying the range:

Worksheets("Chart Data").Range("A1").Offset(Arg2).Select

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


"Morten Hvidberg-Knudsen" <MortenHvidbergKnudsen@discussions.microsoft.com>
wrote in message news:48177CC1-3F55-42E4-96B9-F939D3EB4991@microsoft.com...
> 2007 crashes:
>
> The code below (using a chart event to "navigate" to a specific cell in
> the
> grid) immediately crashes Excel 2007:
> ----------
> Public WithEvents myChartClass As Chart
>
> Private Sub myChartClass_BeforeDoubleClick(ByVal ElementID As Long, ByVal
> Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
> If ElementID = xlSeries And Arg2 > 0 Then ' a point in a series
> Range("A1").Offset(Arg2).Select
> End If
> End Sub
> ------
> Similar code in Excel 2003 (using the SeriesChange event though) works
> fine.
>
> Regards
> Morten
> "Jon Peltier" wrote:
>
>> You could easily adapt one of these approaches:
>>
>> http://www.computorcompanion.com/LPMArticle.asp?ID=221
>>
>> start with the simple click to identify a point.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "Morten Hvidberg-Knudsen"
>> <MortenHvidbergKnudsen@discussions.microsoft.com>
>> wrote in message
>> news:C5F0AB0A-F0FA-40CC-8D00-A5264614C392@microsoft.com...
>> > 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" <CarltonTheDoorman@discussions.microsoft.com>
>> >> wrote
>> >> in
>> >> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
>> >> > 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?????
>> >>
>> >>
>> >>
>>
>>
>>

Worksheets("Chart Data").Range("A1").Offset(Arg2).Clear Works fine
Worksheets("Chart Data").Range("A1").Offset(Arg2).Select Crashes

Then I thought it might be because the spreadsheet was originally created in
2003 (and contained other stuff), so I created a worksheet from scratch in
2007 with only this class, and the assignment to a chart.

Same problem.

I then saved it in 2003 format, and reopened. Same problem.

I finally changed to my old XP / 2003 disk and booted (takes ages, which is
the main reason I changed to Vista / 2007). But when it finally finished
booting the code above worked fine in Excel2003.

So my conclusion is that 2007 has (yet another?) problem. Maybe I really
should consider to "downgrade" to 2003, and postpone my switch to 2007 yet
another year.

One question in this connection: Will running Outlook 2007 and Excel 2003 on
the same machine cause problems ? I like Outlook 2007 and would prefer to
keep it.

regards

Morten

"Jon Peltier" wrote:

> Try qualifying the range:
>
> Worksheets("Chart Data").Range("A1").Offset(Arg2).Select
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Morten Hvidberg-Knudsen" <MortenHvidbergKnudsen@discussions.microsoft.com>
> wrote in message news:48177CC1-3F55-42E4-96B9-F939D3EB4991@microsoft.com...
> > 2007 crashes:
> >
> > The code below (using a chart event to "navigate" to a specific cell in
> > the
> > grid) immediately crashes Excel 2007:
> > ----------
> > Public WithEvents myChartClass As Chart
> >
> > Private Sub myChartClass_BeforeDoubleClick(ByVal ElementID As Long, ByVal
> > Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
> > If ElementID = xlSeries And Arg2 > 0 Then ' a point in a series
> > Range("A1").Offset(Arg2).Select
> > End If
> > End Sub
> > ------
> > Similar code in Excel 2003 (using the SeriesChange event though) works
> > fine.
> >
> > Regards
> > Morten
> > "Jon Peltier" wrote:
> >
> >> You could easily adapt one of these approaches:
> >>
> >> http://www.computorcompanion.com/LPMArticle.asp?ID=221
> >>
> >> start with the simple click to identify a point.
> >>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> Peltier Technical Services, Inc. - http://PeltierTech.com
> >> _______
> >>
> >>
> >> "Morten Hvidberg-Knudsen"
> >> <MortenHvidbergKnudsen@discussions.microsoft.com>
> >> wrote in message
> >> news:C5F0AB0A-F0FA-40CC-8D00-A5264614C392@microsoft.com...
> >> > 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" <CarltonTheDoorman@discussions.microsoft.com>
> >> >> wrote
> >> >> in
> >> >> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
> >> >> > 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?????
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

If the sheet isn't active, you have to activate it before you can select the
cell.

Or use

Application.Goto Worksheets("Chart Data").Range("A1").Offset(Arg2)

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


"Morten Hvidberg-Knudsen" <MortenHvidbergKnudsen@discussions.microsoft.com>
wrote in message news:F8AE8DBA-BF61-4E83-8CF4-EF38FE132CC7@microsoft.com...
>
> Worksheets("Chart Data").Range("A1").Offset(Arg2).Clear Works fine
> Worksheets("Chart Data").Range("A1").Offset(Arg2).Select Crashes
>
> Then I thought it might be because the spreadsheet was originally created
> in
> 2003 (and contained other stuff), so I created a worksheet from scratch in
> 2007 with only this class, and the assignment to a chart.
>
> Same problem.
>
> I then saved it in 2003 format, and reopened. Same problem.
>
> I finally changed to my old XP / 2003 disk and booted (takes ages, which
> is
> the main reason I changed to Vista / 2007). But when it finally finished
> booting the code above worked fine in Excel2003.
>
> So my conclusion is that 2007 has (yet another?) problem. Maybe I really
> should consider to "downgrade" to 2003, and postpone my switch to 2007 yet
> another year.
>
> One question in this connection: Will running Outlook 2007 and Excel 2003
> on
> the same machine cause problems ? I like Outlook 2007 and would prefer to
> keep it.
>
> regards
>
> Morten
>
> "Jon Peltier" wrote:
>
>> Try qualifying the range:
>>
>> Worksheets("Chart Data").Range("A1").Offset(Arg2).Select
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "Morten Hvidberg-Knudsen"
>> <MortenHvidbergKnudsen@discussions.microsoft.com>
>> wrote in message
>> news:48177CC1-3F55-42E4-96B9-F939D3EB4991@microsoft.com...
>> > 2007 crashes:
>> >
>> > The code below (using a chart event to "navigate" to a specific cell in
>> > the
>> > grid) immediately crashes Excel 2007:
>> > ----------
>> > Public WithEvents myChartClass As Chart
>> >
>> > Private Sub myChartClass_BeforeDoubleClick(ByVal ElementID As Long,
>> > ByVal
>> > Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
>> > If ElementID = xlSeries And Arg2 > 0 Then ' a point in a series
>> > Range("A1").Offset(Arg2).Select
>> > End If
>> > End Sub
>> > ------
>> > Similar code in Excel 2003 (using the SeriesChange event though) works
>> > fine.
>> >
>> > Regards
>> > Morten
>> > "Jon Peltier" wrote:
>> >
>> >> You could easily adapt one of these approaches:
>> >>
>> >> http://www.computorcompanion.com/LPMArticle.asp?ID=221
>> >>
>> >> start with the simple click to identify a point.
>> >>
>> >> - Jon
>> >> -------
>> >> Jon Peltier, Microsoft Excel MVP
>> >> Tutorials and Custom Solutions
>> >> Peltier Technical Services, Inc. - http://PeltierTech.com
>> >> _______
>> >>
>> >>
>> >> "Morten Hvidberg-Knudsen"
>> >> <MortenHvidbergKnudsen@discussions.microsoft.com>
>> >> wrote in message
>> >> news:C5F0AB0A-F0FA-40CC-8D00-A5264614C392@microsoft.com...
>> >> > 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" <CarltonTheDoorman@discussions.microsoft.com>
>> >> >> wrote
>> >> >> in
>> >> >> message news:3C7E27EE-D104-41BA-9367-FB64D31AD919@microsoft.com...
>> >> >> > 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?????
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>