Wie kann ich den Rahmen einer Grafik entfernen mittels VB? Hab folgenden Code:
....
'CHO ist das Excel Chart Objekt
With CHO.Chart.Axes(xlCategory)
.ReversePlotOrder = True
.HasMajorGridlines = True
End With
With CHO.Chart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
With CHO.Chart
.HasAxis(xlCategory, xlPrimary) = False
.HasAxis(xlValue, xlPrimary) = True
End With
CHO.Chart.Axes(xlCategory, xlPrimary).CategoryType = xlAutomatic
With CHO.Chart.Axes(xlValue)
.HasMajorGridlines = True
.HasMinorGridlines = False
.MinimumScaleIsAuto = True
.MaximumScale = 100
.MinorUnitIsAuto = True
.MajorUnit = 20
.Crosses = xlAutomatic
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
With CHO.Border
.Weight = 1
.LineStyle = 0
End With
With CHO
.RoundedCorners = False
.Shadow = True
End With
...
Was fehlt hier? Danke für eure hilfe.
MFG Streuner