AnsweredAssumed Answered

Excel 2013 Scatter Chart, Grid Lines vertical color's too light.

Question asked by jachen on Mar 18, 2014
Latest reply on Apr 28, 2014 by arthurabc
I am using Excel 2013 and Window 7.  I created a Scatter Chart. But the Vertical Grid lines' colors are very shallow (light).

I tried to edit the Chart with Excel 's Macro  and then translate it into VEE 9.32.  But VEE 9.32 does not have a library called
RGB().   So the vertical Grid color is still not black.
Sub Macro2()
'
' Macro2 Macro
'

'
    ActiveChart.Axes(xlValue).MajorGridlines.Select
    ActiveChart.SetElement (msoElementPrimaryCategoryGridLinesNone)
    ActiveChart.SetElement (msoElementPrimaryCategoryGridLinesMajor)
    ActiveChart.Axes(xlValue).HasMajorGridlines = True
    ActiveChart.ChartArea.Select
    ActiveChart.Axes(xlValue).MajorGridlines.Select
    ActiveChart.Axes(xlValue).MajorGridlines.Select
    With Selection.Format.Line
        .Visible = msoTrue
        .ForeColor.RGB = RGB(0, 0, 0)  // VEE does not have RGB();
    End With
    With Selection.Format.Line
        .Visible = msoTrue
        .ForeColor.ObjectThemeColor = msoThemeColorText1
        .ForeColor.TintAndShade = 0
        .ForeColor.Brightness = 0
        .Transparency = 0
    End With
End Sub

Please advise. Thanks.  

Attachments

Outcomes