How do I get the chart an Axis is in? RRS feed

All replies

  • Axis.Parent returns nothing for me, I hadn't come across that. Maybe loop other chartobjects on the sheet and in turn the chart's axes, and look for and compare any one or more axis properties that uniquely confirm you've found the selected axis.

    Different approach I alluded to before - maintain 'WithEvents' classes for all charts in the sheet(s). Then in real time the Activate event will notify you which chart has been activated and the Select event will notify you which particular chart element has been selected.

    Sunday, October 28, 2018 9:10 AM