+ Reply to Thread
Results 1 to 3 of 3

reformatted multiple series to use the same marker symbol

Hybrid View

  1. #1
    Registered User
    Join Date
    07-03-2016
    Location
    Round Rock, Texas, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    2

    Post reformatted multiple series to use the same marker symbol

    I have a scatter plot with a single independent value (x) and 60 or so series of independent values (y's). The scatter plot using the default values is impossible to understand. The format for the individual series can be edited, but what a pain. A solution for a similar problem addressing formatting with lines was given by Andy Pope on 10-15-2009. Is there a similar solution for charts of symbols that do not use lines?

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

    Re: reformatted multiple series to use the same marker symbol

    Sub FormatMarkers()
        
        Dim cht As Chart
        Dim ser As Series
        
        On Error Resume Next
        Set cht = ActiveChart
        On Error GoTo 0
        
        If cht Is Nothing Then
            MsgBox "Please select a chart first"
        Else
            With cht
                For Each ser In cht.SeriesCollection
                    ser.MarkerStyle = xlMarkerStyleCircle
                    ser.MarkerSize = 2
                    ser.MarkerForegroundColor = vbBlack
                    ser.MarkerBackgroundColor = vbBlack
                Next
            End With
        End If
    End Sub
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-03-2016
    Location
    Round Rock, Texas, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    2

    Re: reformatted multiple series to use the same marker symbol

    Fantastic! Works brilliantly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing marker size and line width of multiple series on multiple sheets
    By kbannuru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2014, 06:04 AM
  2. Changing Marker Color on Series in Chart
    By Gary_C in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2013, 12:20 PM
  3. Can I associate excel marker style with series name?
    By Marmot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2013, 07:19 AM
  4. reformatting both line and marker style for all series
    By cwyn in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-16-2012, 07:21 AM
  5. scatter graph and marker labels with multiple series
    By tkotko123 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-01-2011, 05:29 PM
  6. Excel 2007 : Format Data Series (Marker Option)
    By nilz23 in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:25 AM
  7. Multiple Series, Same Marker
    By Fizx_Phun in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2010, 12:24 PM
  8. Series Marker on Chart
    By Ralem in forum Excel General
    Replies: 5
    Last Post: 04-20-2010, 04:17 AM

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