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
|