jimbois
Newbie
Joined: 16 Sep 2010
Posts: 3
Location: Poconos
|
 Posted: Fri Feb 25, 2011 7:14 am Post subject: Macro To Change Chart Line Size and Line Color - CALC |
 |
|
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 |
|
