Max and min points from scattered chart

%3CLINGO-SUB%20id%3D%22lingo-sub-708508%22%20slang%3D%22en-US%22%3EMax%20and%20min%20points%20from%20scattered%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHow%20can%20I%20find%20maximum%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Eand%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bminimum%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Epoints%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bfrom%20each%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Epeak%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Eand%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Blow%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Epoints%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bat%20scattered%20chart.%20I%20wanted%20to%20average%20the%20maximum%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Eand%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bminimum%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-search-match-lithium%20lia-search-match-lithium%22%3Epoints%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3BIs%20there%20any%20formula%20suggestions%2C%20please%3F%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20432px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119796i698E8E4283FB467D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%201.JPG%22%20title%3D%22Capture%201.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712007%22%20slang%3D%22en-US%22%3ERe%3A%20Max%20and%20min%20points%20from%20scattered%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87302%22%20target%3D%22_blank%22%3E%40Otgondavaa%20Dashnyam%3C%2FA%3E%26nbsp%3BHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20product%20are%20you%20referring%20to%3F%20I%20can%20help%20direct%20you%20to%20the%20right%20place%20to%20ask%2C%20or%20move%20your%20question%20to%20that%20space.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How can I find maximum and minimum points from each peak and low points at scattered chart. I wanted to average the maximum and minimum points Is there any formula suggestions, please? 

 

Capture 1.JPG

1 Reply

@Otgondavaa Dashnyam Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions.

 

What product are you referring to? I can help direct you to the right place to ask, or move your question to that space.