I am trying to create a chart with two vertical lines that are moveable
by the user clicking and dragging them to a spot on the chart. One line
is for the starting x value and one is for the ending x value inside the
given range.

Once I have the start and end lines placed I would like to do an
average of all the values that fall in between them. And also find the
min/max values.

What I am having trouble doing is creating a vertical line that a user
can click on and move to whatever x value they want. I can create the
line but how do I assign it's position to a particular x value???

Any ideas would be appreciated.

Blaine


--
gerein
------------------------------------------------------------------------
gerein's Profile: http://www.excelforum.com/member.php...o&userid=25979
View this thread: http://www.excelforum.com/showthread...hreadid=393458