Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grabbing Mins/Maxs Off a Chart
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grabbing Mins/Maxs Off a Chart
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |