excel - How to add an average line to a box and whisker by vba

Question

I am quite new in the vba programming. I wrote a code to create a box and whiskerchart. By hand I can add a average line, see picture boxplot with average line. I can't find out how to do that with vba. The code below works, but how to add a line? hope someone can help. Thanks Eddy

Set Myseries = ActiveChart.FullSeriesCollection()

.Select
ActiveChart.FullSeriesCollection().QuartileCalculationInclusiveMedian = True
    

question from:https://stackoverflow.com/questions/65903297/how-to-add-an-average-line-to-a-box-and-whisker-by-vba

Answer 1

Waitting for answers