[13] グラフ線の装飾
本例で説明は、系列(1)の「終値」であるが、他の系列も同様に変更できる。

   With ActiveChart.SeriesCollection(1)
        .Border.ColorIndex = 1
        .Border.Weight = xlThick
        .Border.LineStyle = xlContinuous
        .MarkerStyle = xlNone
    End With 
@ 線→自動



ActiveChart.SeriesCollection(1).Select
    With Selection.Border
        .Weight = xlThin
        .LineStyle = xlAutomatic  (線→自動)
    End With


.LineStyle = xlNone  (線→なし:なしであり指定の系列は線が付かない)


.LineStyle = xlContinuous(線→指定:指定内容は(2)〜(4)参照)


------------------------------------------------------------------------------------------

A線指定→スタイル


[1] .LineStyle = xlContinuous (細い線)

[2] .LineStyle = xlDash    (長い点線)

[3] .LineStyle = xlDot     (点線)

[4] .LineStyle = xlDashDot   (一点鎖線)

[5] .LineStyle = xlDashDotDot  (二点鎖線)

[6] .LineStyle = xlGray50    (パターン1)

[7] .LineStyle = xlGray75    (パターン2)

[8] .LineStyle = xlGray25    (パターン3)



------------------------------------------------------------------------------------------

B)線指定→色






.Border.ColorIndex = **

ColorIndex番号[**]は下表参照のこと



------------------------------------------------------------------------------------------

C)線指定→太さ


[1] .Weight = xlHairline  (点線)

[2] .Weight = xlThin    (細い線)

[3] .Weight = xlMedium   (少し太い線)

[4] .Weight = xlThick    (太い線)



------------------------------------------------------------------------------------------

Dマーカー

ActiveChart.SeriesCollection(1).Select
With Selection
        .MarkerBackgroundColorIndex = xlAutomatic
        .MarkerForegroundColorIndex = xlAutomatic
        .MarkerStyle = xlNone  (マーカなし)
        .Smooth = False
        .MarkerSize = 5
        .Shadow = False
End With

.LineStyle = xlAutomatic  (マーカ自動)


[1] .MarkerStyle = xlSquare (四角)

[2] .LineStyle = xlAutomatic (菱形)

[3] .MarkerStyle = xlTriangle (三角)

[4] .LineStyle = xlAutomatic (×)

[5] .MarkerStyle = xlStar  (×に中線)

[6] .MarkerStyle = xlDot   (点)

[7] .MarkerStyle = xlDash   (横長点)

[8] .MarkerStyle = xlCircle  (円)

[9] .MarkerStyle = xlPlus   (+)


.MarkerBackgroundColorIndex = 3 → マーカーの背景色指定

.MarkerForegroundColorIndex = 1 → マーカーの前景(線)色指定






【戻る】    【Top画面】    【HPへ】