Posts by PVM1234

    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.