PDA

View Full Version : [SOLVED:] How to get the index of ActiveChart



jyindc
02-11-2017, 10:17 AM
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.

p45cal
02-11-2017, 03:18 PM
I suspect
activechart.parent.placement
is what you want.

jyindc
02-12-2017, 08:23 AM
Thanks very much!