what is the VBA code for referencing to individual points in a line on
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 color
depending on different parameters. is this possible
--
medicenpringle
bj - 28 Jul 2005 21:58 GMT
Ther easiest way to do this is to first record a macro doing what you want.
then you have to modify the macro so that the right data points will be
referenced.
It is hard to describe the code wtihout knowing what you want to do.
> 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 - 29 Jul 2005 00:00 GMT
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
> 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?

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