![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Join Date
Aug 2016 Posts 1 Default How to find local maximas/minimas in-between points that crossed 0 on the x-axis? Apologies if the post title was unclear, here's what I meant. - I have plotted a line graph with only 1 line. - This line ranges between -2% and 1.5%, it looks like a stock graph with ups and downs. - My objective here is to find the maximum or minimum in-between two points that have crossed 0 on the x-axis. The two points that have crossed the x-axis must have a maximum or minimum inside that is ABOVE 1% or BELOW -1%. Further explanation... This line I plotted here has data that goes up and down in-between -2% and 1.5%. Sometimes the line will fluctuate very slightly between -1% and 1%. I'm trying to find all the peaks (maximums) and abysses (minimums) that are over 1% or under -1%, with the crucial condition that the two points surrounding the peaks or abysses must have crossed 0 on the x-axis. If you want clarification, please do not hesitate! Big thanks. |
| Tags |
| excel charts |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel 2016 line chart shows 2 erroneous (zero) data points in x axis. How to remove them? | 5434aw | Excel | 4 | 07-31-2016 07:54 AM |
Trouble using bullet points / sub bullet points within Word 2013
|
Mr Davo | Word | 2 | 04-18-2016 04:31 PM |
| Messages 'crossed out' before moving | marketshare | Outlook | 0 | 01-18-2014 01:13 AM |
| Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 | sharath_ms | PowerPoint | 0 | 07-08-2013 10:06 PM |
| Edit Points in Curve: MS Office changes points properties itself, without my action. | Sergey SPb | PowerPoint | 0 | 08-27-2012 05:33 AM |