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

t84

Original Poster:

6,941 posts

215 months

Wednesday 17th February 2010
quotequote all
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 smile

JayBM

459 posts

216 months

Wednesday 17th February 2010
quotequote all
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

Original Poster:

6,941 posts

215 months

Wednesday 17th February 2010
quotequote all
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

459 posts

216 months

Thursday 18th February 2010
quotequote all
It was definitely in previous versions, so that may be another solution?!?

t84

Original Poster:

6,941 posts

215 months

Thursday 18th February 2010
quotequote all
Theres an add-in that I'm using, its not perfect but its ok smile

t84

Original Poster:

6,941 posts

215 months