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