XY Scatter Chart - Drag individual data points on graph

Darril

unread,

Jan 10, 2008, 2:31:01 AM1/10/08

to

In Excel 2003, I was able to drag individual xy scatter point data to a new
position on the actual graph. This was a great feature when one wanted to
move
data to get them to coalesce with a scanned curve that had been included in
the graph background. I am not able to do this in Excel 2007. Does anybody
know if this feature is available in Excel 2007?

David Biddulph

unread,

Jan 10, 2008, 3:49:27 AM1/10/08

to

No. It isn't.
--
David Biddulph

"Darril" <Dar...@discussions.microsoft.com> wrote in message
news:1A4CB226-1C8F-437C...@microsoft.com...

dvan...@gmail.com

unread,

Mar 4, 2008, 2:05:19 PM3/4/08

to

Another great feature that seems to be missing is the ability to
select a data set in a workbook and drag it to an existing chart.
Does anyone know if this feature is still available?

Seems like Microsoft missed the boat on this one.

Dave

On Jan 10, 12:49 am, "David Biddulph" <groups [at] biddulph.org.uk>
wrote:

> > know if this feature is available in Excel 2007?- Hide quoted text -
>
> - Show quoted text -

Andy Pope

unread,

Mar 4, 2008, 5:53:31 PM3/4/08

to

Hi,

No, if you drag and drop cells on to a chart the cells simple get moved
within the sheet. The new chart object does not capture the dropping of
cells on to it.
You can copy and paste still though.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Guy@discussions.microsoft.com Shaft Guy

unread,

Aug 14, 2008, 5:53:01 PM8/14/08

to

That is really disappointing, one of my most used worksheets took advantage
of that capapbility, without it my worksheet is useless and I will have to
spend time adjusting the two cells until I get the point where I need it.

I'm only demoing 07 right now, I might have to stick with XP unless they
come up with an add on with this feature.

Diti

unread,

Mar 15, 2009, 9:24:01 AM3/15/09

to

Does anyone know if Microsoft has meanwhile created some add-in to enable the
dragging of individual points on a Excel 2007 graph ??
I just can't understand why this VERY useful capability was removed from
Excel 2007 !
----------------------------------------------------------------------------------------

Jon Peltier

unread,

Mar 15, 2009, 10:56:10 AM3/15/09

to

Microsoft decided for whatever reason that this capability was not
important, so it was removed. It is therefore unlikely that Microsoft would
issue an add-in to recreate this capability, and in fact, they have issued
no such add-in. Perhaps they have heard the outcry and will revive the
feature for the next version of Excel.

I am working on a utility which will work much the same as the original
feature did, but it's still on the drawing board.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

"Diti" <Di...@discussions.microsoft.com> wrote in message
news:9D3F821F-46DF-4590...@microsoft.com...

and Drop data points in excel chart@discussions.microsoft.com Drag and Drop data points in excel chart

unread,

May 20, 2009, 10:02:01 AM5/20/09

to

I fully agree this was agreat feature for fitting areas or tracing
perfomance. Quite frnakly if I had known this option was not available I
would not have purchased and stuck with the 2002 version of excel.