referencing lines and series points

Hi,

The Macro Recorder is useful for tasks like this. Giving you an insight
into the objects and properties needed.

Sub Macro2()
'
' change the line between points and 4 to red
'
ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).Points(4).Select
With Selection.Border
.ColorIndex = 3
.Weight = xlThin
.LineStyle = xlContinuous
End With
'
' change marker to red circle black border size 10
'
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerForegroundColorIndex = 1
.MarkerStyle = xlCircle
.MarkerSize = 10
.Shadow = False
End With
ActiveChart.PlotArea.Select
End Sub


Cheers
Andy

medicenpringles wrote:
> what is the VBA code for referencing to individual points in a line on a
> line graph? i would like to create a macro to change indiviual points'
> shapes and the color or the lines in between them to different colors
> depending on different parameters. is this possible?
>
>

--

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