Hi,

Using the macro record generated this code when changing 2 points on a
line series.

You can edit the code to get rid of all the select/selection stuff.


ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).Points(3).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
With Selection
.MarkerBackgroundColorIndex = 6
.MarkerForegroundColorIndex = 3
.MarkerStyle = xlCircle
.MarkerSize = 9
.Shadow = False
End With
ActiveChart.SeriesCollection(1).Points(5).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
With Selection
.MarkerBackgroundColorIndex = xlAutomatic
.MarkerForegroundColorIndex = xlAutomatic
.MarkerStyle = xlTriangle
.MarkerSize = 5
.Shadow = False
End With

Cheers
Andy

Techno_Dex wrote:
This is a cross post, as I had been pointed to this group and an alt. after
I had posted originally. Hoping this one can help.

How do I access the Points in a Chart of type Line? I'm wanting to display
the Values at each point and modify various aspects like size and color. So
far I have not found the proper combination of properties to access these
point, and the access method is different for every chart type. Any ideas?

I guess what I'm really asking is how do I access the Point Labels on a Line
Chart.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info