Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a value out off a chart just by a mouse click
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a value out off a chart just by a mouse click
Hi Rody,
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? Sure. See Chapter 15 from PED, available for download on my web site, which shows how to convert between mouse click coordinates to data coordinates. Regards Stephen Bullen Microsoft MVP - Excel Professional Excel Development The most advanced Excel VBA book available www.oaltd.co.uk/ProExcelDev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right Mouse Click | Excel Discussion (Misc queries) | |||
right mouse click not working | Excel Discussion (Misc queries) | |||
Each Click of the Mouse | Excel Discussion (Misc queries) | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Mouse Click Event | Excel Programming |