VBA get name of point in Chart series

Hi all,

I'm tearing my hair apart here trying to get the name of any given point in a stacked column chart. When mousing a point I get a tooltip that says "Series "[series name]", Point "[point name]", Value 84".

What I want to do is to get the Name of the point displayed with VBA - this is all a part of a search and find algorithm for certain data points in a dynamically created chart.

However, trying to get that name is frustrating at best.

Trying this: ActiveChart.SeriesCollection(1).Points(1).Name just gives me "S1P1", which is really just shorthand for "Point number one in Series number 1".

Getting the series name is very easy - ActiveChart.SeriesCollection(1).Name returns the name of the series, not in any "S1" notation, but the actual name.

How then, do I go about getting the name of any specific point?

Have also tried ActiveChart.SeriesCollection(1).Points(1).DataLabel.Parent.Name but this also just gives me "S1P1". But since the mouseover tooltip provides the actual name of the point there must be a way to get that programatically with VBA.

Grateful for any help with this.

Thanks,

Marcus

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.