Name of a chart series Point

C

Candyman

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
 
C

Candyman

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.
"
 
J

Jon Peltier

Do you mean the data label?

pn = ActiveChart.SeriesCollection(s).Points(p).DataLabel.Text

- Jon
 
C

Candyman

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

THANKS!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top