Drag & Drop Chart Series Points At Run Time (Help Needed From Excel VBA Gurus)

Hi,

I wanted to know if there is a way in VBA to Drag & Drop Chart Series Points At Run Time?

So If I drag & Change values on the chart, the underlying data values should change.

Helpful Link -

http://www.syncfusion.com/kb/60/how-...ts-at-run-time

Cheers!

Deep

Graphical goal seek was removed in xl2007. Or more accurately it was not included in the new charting engine for xl2007.

There is an addin that may be of use.
http://blogs.office.com/2009/11/02/e...n-charts-mpoc/

Charts do have events you can hook into but the biggest issue is converting the x y mouse values between the various scaling systems used.

Thank you Andy for replying..

So basically the Link I shared in the 1st post cannot be used in Post 2007 VBA Versions? Is that so?

The link you posted is to .net code not VBA

it also refers to chart control on a windows form and is nothing to do with excel.

Alright! I thought something of that sore was possible with Excel VBA.

Anyways thank you for the guidance..

Cheers!

It is but it is complicated by having to do lots of work arounds.
google chart events to see what's available

No problem! Thnx