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.
Bookmarks