Excel 2007: Possible to use a chart to edit data?

[t84]

Wondering if anyone on here can help me...

Basically I want to edit data by clicking and dragging lines on a chart, is this possible? (I can use VBA)

Thanks

[JayBM]

In their infinite wisdom Microsoft decided to remove this functionality from Excel 2007!

A while ago I had a brief look at recreating it via some VBA but gave up as I think the effort required to do it was more than it was worth.

[t84]

Interesting, was it in previous versions then? I can't find any information about it on the web.

That's really annoying... Office 2007 is AWFUL!

[JayBM]

It was definitely in previous versions, so that may be another solution?!?

[t84]

Theres an add-in that I'm using, its not perfect but its ok

[t84]

http://blogs.msdn.com/excel/archive/2009/11/02/exc...