Consulting

Results 1 to 3 of 3

Thread: How to get the index of ActiveChart

  1. #1
    VBAX Newbie
    Joined
    Feb 2017
    Posts
    4
    Location

    Question How to get the index of ActiveChart

    I'm trying to use VBA to change the .Placement setting on the ActiveChart, but this property is only available for ChartObject(index). How can get either get the index number of the ActiveChart or how can I otherwise refer to the ActiveChart using ChartObject. I've tried activechart.name, activechart.index, setting a chart object variable to active chart, all of which error.

    Thanks in advance for any help.
    Last edited by jyindc; 02-11-2017 at 10:59 AM.

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    I suspect
    activechart.parent.placement
    is what you want.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Newbie
    Joined
    Feb 2017
    Posts
    4
    Location
    Thanks very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •