Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

8 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

eugenio shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Accepting Votes  ·  Scott Ruble (PM MSFT) responded  · 

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?

Thanks,
Scott [MSFT]

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base