referencing lines and series points
 

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?


--
medicenpringles


------------------------------------------------------------------------
medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458
View this thread: http://www.excelforum.com/showthread...hreadid=391019

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