+ Reply to Thread
Results 1 to 2 of 2

drawing lines in VBA

  1. #1
    Forum Contributor
    Join Date
    06-04-2006
    Posts
    132

    drawing lines in VBA

    Hi,

    I wonder if i could get some help here. I was trying to draw a line between points in the XY coordinates graph in Excel 2002. How do i go about this in VBA?

    Thank you in advance

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: drawing lines in VBA

    You would need to calculate the x and y position values by determining the axis value range and it's left/top/width/height properties.

    If you could make use of a dummy series you may get the desired result without the need to calculate the extra information.

    What exactly are you trying to do?
    Do you have examples of the desired output that you can post or link to?
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1