Name of a chart series Point
 

How do I get the name of a chart series Point?
I can not figure the property...
For p = 1 To PointsCount
pn = ActiveChart.SeriesCollection(s).Points(p).Label

TIA

Name of a chart series Point
 

IN other words what property do I ask for to determine the label/name? I want
to omit markers for any data point of year 2006. so If
right(Point_Name,2)="06" then no lines or markers.
"
"Candyman" wrote:

How do I get the name of a chart series Point?
I can not figure the property...
For p = 1 To PointsCount
pn = ActiveChart.SeriesCollection(s).Points(p).Label

TIA

Name of a chart series Point
 

Do you mean the data label?

pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Candyman" wrote in message
...
IN other words what property do I ask for to determine the label/name? I
want
to omit markers for any data point of year 2006. so If
right(Point_Name,2)="06" then no lines or markers.
"
"Candyman" wrote:

How do I get the name of a chart series Point?
I can not figure the property...
For p = 1 To PointsCount
pn = ActiveChart.SeriesCollection(s).Points(p).Label

TIA

Name of a chart series Point
 

Very close!
I actually saw the response to Thompson as well. I added :
ActiveChart.SeriesCollection(s).Points(p).HasDataL abel = True
pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text
(That got me the data label)
z = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(s).XValues, p)
(This got me the data point title, PERFECT!)
y = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(s).Values, p)

THANKS!

"Jon Peltier" wrote:

Do you mean the data label?

pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Candyman" wrote in message
...
IN other words what property do I ask for to determine the label/name? I
want
to omit markers for any data point of year 2006. so If
right(Point_Name,2)="06" then no lines or markers.
"
"Candyman" wrote:

How do I get the name of a chart series Point?
I can not figure the property...
For p = 1 To PointsCount
pn = ActiveChart.SeriesCollection(s).Points(p).Label

TIA