Name of a chart series Point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Similar Threads

Returning a series collection end Point value 1
Bubble Chart 1
add a chart in a Add-In 1
add labels to line chart 7
VBA Code to move DataLables to top of Chart 4
Using Range names in selecting chart series. 1
Charts Having X Axis Scaled Using Calendar Weeks 4
adding a data series to a chart with variable inputs. 2

Back
Top