Please Help with graph question

[egraham3]

I am still looking for a way to find the max in a range in my series, and add a marker to only that point on my XY scatter plot.

i dont think its that hard, i just cant get the code to act right.

 

[VoG]

This may help http://peltiertech.com/Excel/Charts/PointAtPoints.html

 

[egraham3]

i should have clarified more clearly,

im adding this graph through VBA. any other links? lol

 

[VoG]

See if you can find something here http://peltiertech.com/Excel/Charts/ChartIndex.html#C

 

[egraham3]

this is my code

 Set timeRange = newSH.Range("H2", Range("H2").End(xlDown))
    Set heightRange = newSH.Range("I2", Range("I2").End(xlDown))
    Set tempRange = newSH.Range("J2", Range("J2").End(xlDown))
    
    
    Application.ScreenUpdating = False
        'Adds chart, with 2 series (time vs height rise) and (time vs temp rise)
    With newSH.ChartObjects.Add _
            (Left:=428, Width:=498, Top:=0, Height:=380)
            .Chart.ChartType = xlXYScatterSmoothNoMarkers
            .Select
        End With
    With ActiveChart.SeriesCollection.NewSeries
    .XValues = timeRange
    .Values = heightRange
    .Name = "Foam Height (in.)"
    With .Border
        .ColorIndex = 5
        .Weight = xlThick
        .LineStyle = xlContinuous
        End With
    End With

i want to find max value in height range, and add a marker.

 

[egraham3]

still need help