+ Reply to Thread
Results 1 to 4 of 4

Xl 2007 VBA applying round dot format to chart series

  1. #1
    Forum Moderator - RIP 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
    29,464

    Xl 2007 VBA applying round dot format to chart series

    Hi,

    Does anyone know the syntax for formatting a chart series plot line as 'round dot'.

    I've tried all sorts of variations and additions to
    Please Login or Register  to view this content.
    with no luck and most unhelpfully the macro recorder is no use.

    Also tried intellisensing via the MS help, but it must be me since no help is forthcoming. I've seen references by Andy and Jon in other areas of the web which seem to suggest some are harder to discover than others.

    Is there a document anywhere which summarises this sort of stuff?

    Usual TIA
    Richard Buttrey

    RIP - d. 06/10/2022

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

  2. #2
    Forum Moderator - RIP 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
    29,464

    Re: Xl 2007 VBA applying round dot format to chart series

    Ah.... re the last post.

    I've found the syntax....

    Please Login or Register  to view this content.
    seems to work. Now all I want to find is the instruction that sets the width of the dots.....

    Rgds

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

    Re: Xl 2007 VBA applying round dot format to chart series

    try,

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Moderator - RIP 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
    29,464

    Re: Xl 2007 VBA applying round dot format to chart series

    Cheers Andy,

+ 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