jimbois
Newbie
Joined: 16 Sep 2010
Posts: 3
Location: Poconos
|
 Posted: Tue Apr 19, 2011 3:11 am Post subject: How To Change Chart Variable Line Size & Color With A Ma |
 |
|
I can't locate how to change a CALC line chart, line color and line size.
The equivalent VBA code would be similar to:
Sheets("Chart_MVS4_DIORQ").Select
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 3
.Weight = xlMedium
.LineStyle = xlContinuous
End With
With Selection
.MarkerBackgroundColorIndex = xlNone
.MarkerForegroundColorIndex = xlNone
.MarkerStyle = xlNone
.Smooth = False
.MarkerSize = 3
.Shadow = False
End With
ActiveChart.Deselect
_________________
jimbo |
|
