Chart Marker Border

**pogopuschel** · 03-26-2010, 04:23 PM

Hello,

My Excel Version is 2007.

I am trying to recreate a Chart programatically via VBA. I want to change the border type of single marker but cannot figure out how to do it. The Excel.Point object does not seem to have properties to change the Marker Border style, even though I can do it manually in Excel.
I tried to record a macro which does it, but no code is being written. I can only guess that the libraries not yet support that feature, but is there any way to change the border of a single point (marker)?

Thank you so much!
Thomas

**teylyn** · 03-26-2010, 07:27 PM

Hello Thomas,
here are a few pointers

    ActiveChart.SeriesCollection(1).Select
    With Selection
        .MarkerStyle = 2
        .MarkerSize = 7
    End With
    With Selection.Format.Fill
        .Visible = msoTrue
        .ForeColor.ObjectThemeColor = msoThemeColorAccent2
        .ForeColor.TintAndShade = 0
        .ForeColor.Brightness = 0.400000006
        .Transparency = 0
        .Solid
    End With
    With Selection.Format.Line
        .Visible = msoTrue
        .ForeColor.ObjectThemeColor = msoThemeColorAccent5
        .ForeColor.TintAndShade = 0
        .ForeColor.Brightness = -0.25
        .Transparency = 0
        .Weight = 1
        .DashStyle = msoLineSysDot
    End With

Thread: Chart Marker Border

Thread Tools

Display

Chart Marker Border

Re: Chart Marker Border

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions