Gridlines on Secondary axis

Question

I have a graph (produced by a Userform in VBA) with both a primary and secondary y-axis exist. I wish to place gridlines only on the secondary axis, WITHOUT those on the Primary being present! How do I do this (??), at the moment gridlines appear for both the Primary and Secondary y-axis. This is the code I am using:

     With ActiveChart
       .HasTitle = True
       .ChartTitle.Characters.Text = "title"
       .Axes(xlCategory, xlPrimary).HasTitle = True
       .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Dates"
       .Axes(xlValue, xlPrimary).HasTitle = True
       .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Dollar"
       .Axes(xlValue, xlPrimary).TickLabels.NumberFormat = "0"
       .Axes(xlCategory).HasMajorGridlines = True
       .Axes(xlValue, xlSecondary).HasMinorGridlines = True
       .Legend.Position = xlLegendPositionRight

   End With

HELP!!!! Please, I would be most grateful for any assistance here! Thank you

score 0 · Accepted Answer · answered Aug 02 '16 at 12:24

0

If your Chart already has the Seconday Y-Axis configured, then you need to add the 2 following line inside your With statement:

With ActiveChart
    ' do all your regular actions

    ' hide Primary Y-Axis Gridlines
    .SetElement (msoElementPrimaryValueGridLinesNone)

    ' Show Secondary Y-Axis Gridlines (Major)
    .SetElement (msoElementSecondaryValueGridLinesMajor)

End With

answered Aug 02 '16 at 12:24

Shai Rado

33,032
6
29
51

Thanks! That is a nice solution – Aug 02 '16 at 12:45
@MrNemo if it's answered your post, please mark as answer – Shai Rado Aug 02 '16 at 12:47

Gridlines on Secondary axis

1 Answers1