Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find 2 lowest point to form a trendline | Excel Worksheet Functions | |||
I want to find the lowest point on the plotted line in a graph. | Charts and Charting in Excel | |||
REPOSITION HIGHEST VALUE ON LINE CHART | Charts and Charting in Excel | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
How to change color of line and point markers on a line graph | Charts and Charting in Excel |