I am trying to create charts through VBA, and want the (default) line around it removed. If you know the shape name, that would be something like
I believe that line is not in the chart, but in the parent shape of it. So I tried to add it to the shape-related actions I am doing as well
Code
With ActiveChart.Parent
.Height = 325 ' resize
.Width = 500 ' resize
.Top = 100 + 335 * (j - 25) ' reposition
.Left = 4000 ' reposition
.Line.Visible = msoFalse 'this is the line that it is all about, and that gives the error
End With
, but that gives an error. Any thoughts on what I am doing wrong?