+ Reply to Thread
Results 1 to 3 of 3

Auto detect and label the peaks and botttoms of a graph?

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2013
    Posts
    76

    Auto detect and label the peaks and botttoms of a graph?

    Hello,

    I was wondering if excel can auto label peaks and bottoms of a graph? Let me go further:

    I have a graph that has one data number for every day of the year (365). This is a natural up and down curve, similar to a stock.

    Can excel find the key high and low points? I have attached an example that I think may help. In it you will see I have quickly labeled the key tops and bottoms. CHART TEST.xlsxCHART TEST.xlsx.

    I basically omitted the peaks/bottoms that are very short term and irrelevant.

    Thanks so much in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Auto detect and label the peaks and botttoms of a graph?

    You should be able to do the desired auto-labeling via VBA.
    As to what consitutes a Key point - that you would need to clearly define for Excel. From what I see, trend-reversal seem to be the common attribute for all key points. However, you'd need to define it in more specific terms - like percentage change, or minimum difference between two consecutive lows or highs - so they maybe labelled accordingly.

    Basically, first you label all the points, and then delete the labels that do not meet the "Key" criteria.
    HTH!

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: Auto detect and label the peaks and botttoms of a graph?

    To label the points simply add another data series and apply data labels to it.
    For any point you don't want displayed use =NA() instead of the data value.

    Determining which points constitute a peak or a trough may require VBA.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting number of peaks in graph
    By evydmb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-05-2013, 06:10 PM
  2. Replies: 1
    Last Post: 11-02-2009, 09:00 AM
  3. Auto Cell Detect
    By Ssam87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2009, 06:35 PM
  4. [SOLVED] Need to get slope of peaks on excel graph
    By Capillod in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1