Re: Add Horizontal Line to Chart Without Creating New Series
To create line I am using shape objects. for my requirement I cannot use new series. Following is the piece of code I am using to create the line. When I run the macro in debug mode the line is created at intended location, but if I run in normal mode the line location and size is entirely different.
Set mysheet = Worksheets(ShtNam)
With mysheet.Shapes.AddLine(49.21, 95.83, 342.8, 95.83).Line
.DashStyle = msoLineSolid
.Weight = 1.5
.Style = msoLineSingle
.ForeColor.SchemeColor = 10
End With
Can any one tell me how this issue will be solved.