View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Get a value out off a chart just by a mouse click

Charts have events, including a MouseDown event, that could be used to trap a
mouse click and determine the location - as x and y values representing
distance from the upper left corner of the ChartArea (not to be confused with
any coordinates used in your chart). But to use this to find a specific and
accurate point using your chart coordinates would be quite difficult in
practice, I would think, since there are multiple (and variable) scaling
factors involved (what is the size and location of the PlotArea? Then what
type of chart is it? Where is the origin of the axes? What scale are you
using currently in the chart...). You would need to develop a custom class
to do all of this; seems to me it would be quite difficult!

"Rody" wrote:

Is it possible to get the value of the X-ax out of a chart just by clicking
in the chart? What i want is to zoom in on a given chart area by clicking on
the start and stop range. If i have the X-ax value's, (it's a time stamp), i
can select the new source for the "zoomed" chart.

Any ideas?

Grtz,
rody