The official documentation is at Language reference for Visual Basic for Applications (VBA). The formal syntax is available in a PDF at VBA Language Specification. The VBA Language Specification however answers the question about all the syntax for VBA expressions. I suspect that you are actually looking for something that explains VBA and that the documentation is inadequate for you.
Look at Workbook.ActiveChart property. It is a Chart object. They have a Chart.SeriesCollection method that returns either a single Series object or a collection of Series objects. You can similarly drill down from there.
Thank you for that comprehensive answer. I have for years been using the Language Reference pages without realising that the route that I need to follow is to click on the link at the top of the page to the object that is returned. The VBA Language Specification is new to me, and I am pleased to see that it appears to have a very comprehensive contents list and a good index. With thanks, Andrew Collins
Sign in to comment
You may also find the following website useful.
It contains a complete list of all the VBA built-in functions and operators.