Excel 2016 Box Plot - VBA to Remove Inner Points

[erock24]

The 2016 Box plot graph allows user to show "Inner Points". Has anyone figured out if VBA can check/uncheck this option? No code gets generated with the recorder.

Thanks for time and help,
-Erock

 

[pbornemeier]

I don't have 2016, so I cannot help directly, but the following has helped me in similar circumstances:
Select the chart.
Run this VBAcode:

Sub CheckChart()
    Dim x
    Set x = ActiveSheet.ChartObjects(1)
    Stop
End Sub

With the code stopped, explore the object tree structure in the VBE locals window to see if the inner points branch exists and then experiment with manipulating it.
Please post back if you find the answer to your question.

 

[erock24]

Cool Trick. I'm not seeing anything, which is a bummer, but thanks for the tip.

 

[pbornemeier]

One other exploratory tip is to open the VBE and click F2 to get the 'Object Browser' activated. You can then search libraries with terms you feel apply to your situation. This may lead you to an object you can manipulate.