Expose more related charting objects in VBA (a points' values, range, series, etc)
It is not possible to access a point's values or range from VBA. We have to parse the point's name (S3P14), the go to the third series' 14th cell in the x values range to access the points' value or range.
It is also not possible to access a series' legend entry as a property from VBA.
There are many examples of this kind of "incompleteness" of the VBA charting object model. It would be great if these related objects could be exposed, to simplify code.
Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.
Could you further comment on the other areas which you feel are incomplete?
Can you add a way to set the weight of gridlines to a specific point? Right now the settings are too general at thin, thick, etc.