View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cristiano[_3_] Cristiano[_3_] is offline
external usenet poster
 
Posts: 5
Default Changing plot color

I have a scatter graph with a few thousand points linked with a smoothed
line.
To change the color, the width and the dash style to the points from
Rini to Rfin-1 I wrote this loop:

For r = Rini To Rfin - 1
With GRA.SeriesCollection(1).Points(r).Format.Line
.ForeColor.RGB = colore
.Weight = W
.DashStyle = dash
End With
Next

but it's terribly slow.
Is there any way to speed it up?

Thank you
Cristiano