+ Reply to Thread
Results 1 to 3 of 3

How to add the direction arrows to lines in an XYscatter

  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    9

    How to add the direction arrows to lines in an XYscatter

    Excel 2007 allows you to format your lines in an XYscatter chart with direction arrows. I cant find the proper method for programming that function in VBA. Can anyone help point me to where this might be documented or tell me the secret.

    On a different note:
    As a new vba for excel 2007 programmer I've never had so much trouble figuring out how to do simple stuff. I have not found "the" source that documents fully each function/method/object that are used in excel VBA.

    Here's one thats been bothering me:
    For instance, when you are looping through the columns in a range like this:

    dim myselection as range
    dim cols as range
    for each cols in myselection.columns
    {bla bla bla}
    next cols

    Doesn't the "cols" object have an indexing variable available. I've resorted to adding my own index counter for each loop but surely there has to be an iteration count in the object??
    Last edited by kb9nvh; 03-11-2011 at 03:22 PM.

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

    Re: How to add the direction arrows to lines in an XYscatter

    End arrow head
    Please Login or Register  to view this content.
    No built in index when for each looping. You need to maintain one if required.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-10-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: How to add the direction arrows to lines in an XYscatter

    Quote Originally Posted by Andy Pope View Post
    End arrow head
    Please Login or Register  to view this content.
    No built in index when for each looping. You need to maintain one if required.
    Man, Thanks so much!!!
    Also, on the indexing, maybe I'm just stuck in my old ways of thinking and maybe I shouldn't really need that index at all but there has been so many times that I decide I could take care of some other task while iterating through columns or whatever but I need to know "odd or even" or want to look at every third one or whatever and I'm stuck without a counter.

    Thanks again!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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