Grabbing Mins/Maxs Off a Chart

[Chris]

I'm looking for a macro or other function that will allow me to quickly grab
a maximum or minimum point off from a graph or portion of a graph. I have
1,000 data points that have several maxs and mins and ideally I'd like to
grab a box with the cursor and determine the max/min of those data points.

[Jon Peltier]

Chris -

This might get you started. You click on a point and the macro tells you the
data:

http://peltiertech.com/Excel/Charts/...html#PointInfo

This is a more detailed description of chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Chris" <[email protected]> wrote in message
news:[email protected]...
> I'm looking for a macro or other function that will allow me to quickly
> grab
> a maximum or minimum point off from a graph or portion of a graph. I have
> 1,000 data points that have several maxs and mins and ideally I'd like to
> grab a box with the cursor and determine the max/min of those data points.