+ Reply to Thread
Results 1 to 6 of 6

VBA code to format scatter markers

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    VBA code to format scatter markers

    Hi All,

    Does anyone have a code to format markers for 103 series in a scatter all in the same way?

    Thanks

    C

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,987

    Re: VBA code to format scatter markers

    Hi,
    Not sure what you man by 103 series but does

    Please Login or Register  to view this content.
    help?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: VBA code to format scatter markers

    Each line on a line graph is called a series.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,987

    Re: VBA code to format scatter markers

    Hi,

    @darknation

    I'm well aware what a series means.

    @ctriboy
    Are you saying that you really do have 103 individual lines on a scatter chart!
    Without being presumptious is that really the best way of presenting that amount of detail. - Wood and trees springs to mind.

    However if you really do want to format all 103 series then use the code I gave you but put it in a loop, and use the loop counter instead of the (1) in the SeriesCollection(1)

    Regards

  5. #5
    Registered User
    Join Date
    12-14-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: VBA code to format scatter markers

    thanks for looking into my request. Attached is the data I am working with if this helps. thanks very much
    Attached Files Attached Files
    Last edited by ctriboy; 03-09-2012 at 12:06 PM.

  6. #6
    Registered User
    Join Date
    12-14-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: VBA code to format scatter markers

    Thanks all, have been able to fix it now

+ 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