If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
how to add animation to a chart - make lines appear | David Leonard | Powerpoint | 11 | June 2nd, 2005 12:33 AM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Scrollbar on Chart Jumps to Left when Chart is Clicked | Bob | Charts and Charting | 5 | May 1st, 2005 02:06 AM |
build chart template; then add series one by one | L Mehl | Charts and Charting | 2 | February 12th, 2004 10:53 PM |