LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 173
Default Find 2 highest point to form resistance line

Dear expert,

Have left a post for finding 2 lowest point for form a support line.
Now, would like to find 2 highest point to form a resistance line.
Data is from an array for formula.

In this case, should choose 91.27 and 87.96 to form resistance line.
Although 89.95 is higher than 87.96, line is forward plotting.

Is it possible?
If the highest in last row, can show "No line".
Thanks

52.35 26-Jan-10
59.87 18-Feb-10
89.95 26-Feb-10
85.41 05-Mar-10
91.27 10-Mar-10
87.96 23-Mar-10
36.69 29-Mar-10


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find 2 lowest point to form a trendline Elton Law[_2_] Excel Worksheet Functions 0 April 11th 10 03:54 PM
I want to find the lowest point on the plotted line in a graph. Edwin Charts and Charting in Excel 4 November 22nd 08 03:39 PM
REPOSITION HIGHEST VALUE ON LINE CHART RPM7 Charts and Charting in Excel 1 November 26th 07 01:18 PM
Data point on line is not over the point/tick in X axis... TomCat Charts and Charting in Excel 2 September 6th 07 01:36 PM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 06:43 PM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"