Correct me if I'm wrong, but it this code looks like it's modifying the
Markers, not the Labels/Values that those Markers represent? (i.e. If the
first Marker is a value of 5.4, will this code actuallly set the
background/forground color for the value 5.4 or does it set the
background/forground color for the Circle/Triangle Marker that represents
the point 5.4)



"Andy Pope" wrote in message
...
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