Adding only a bottom border line to a excel chart

[Alexander_Golinsky]

Hi all please help.

Basic question, but it seems there is no solution to it. How do you add only a bottom border line to an excel chart? Not all 4 borders, but one.

Many thanks in advance!

[Alexander_Golinsky]

Well, do not believe it has any solution. Here is my workaround:

Sub Bottom_edge()
Dim sh As Worksheet
Dim ch As ChartObject

For Each sh In ActiveWorkbook.Sheets
    For Each ch In sh.ChartObjects
        ch.Select
        ActiveChart.Shapes.AddConnector(msoConnectorStraight, 0, ch.Height, ch.Width, ch.Height).Select
        Selection.ShapeRange.Line.ForeColor.RGB = RGB(0, 0, 0)
    Next
Next

End Sub

The procedure simulates the bottom border by inserting line exactly like it is the bottom border. The key issue is if you copy then the chart, the border goes with it.